SELECT /*+ PARALLEL */
count(*) AS count,
user_id, program, module, sql_id
FROM SYS.DBA_HIST_ACTIVE_SESS_HISTORY
WHERE sample_time > TO_DATE('24-JAN-2016 08:00:00','DD-MON-YYYY HH24:MI:SS')
AND sample_time < TO_DATE('24-JAN-2016 08:10:00','DD-MON-YYYY HH24:MI:SS')
--AND program LIKE 'oracle@%'
GROUP BY user_id, program, module, sql_id
ORDER BY count(*) desc
Parallel Queries
Parallel Queries
