ASH sampling
Dear Experts,
We have a session started yesterday at 14-JUL-2023 22:00:00 PM,it is still running. We are querying the ASH to find out which sql is seen most. We are usingbelow query from dba_hist_active_sess_history. But it shows the first sql seen for 33 hours,but it not in reality. Are we checking something wrong?
SELECT ash.SQL_ID,ash.event,count(*)*10 FROM dba_hist_active_sess_history ash , dba_users u WHERE u.user_id=ash.user_id and ash.sample_time BETWEEN to_date('14-JUL-2023 22:00:00','DD-MON-YYYY HH24:MI:SS') and to_date('15-JUL-2023 15:00:10','DD-MON-YYYY HH24:MI:SS') and session_id=521 and session_Serial#=22192 group by ash.SQL_ID,ash.event order by 3 desc; SQL_ID EVENT COUNT(*)*10 ------------- ------------------------------ ----------- bzj08ydszd31g 121260 bzj08ydszd31g db file sequential read 340 bzj08ydszd31g gc current block 2-way 60 8k1k3u2v5f5a2 db file sequential read 40