Missing of SQL_ID in v$active_session_history
Hello!
my Oracle database is 11.2.0.4(Linux)
Can You please explain, how to investigate the reason(s) of missing of SQL_ID (in my case this is the line with execution count =2451) ?
SELECT count(*) , ash.SQL_ID
FROM v$active_session_history ash , dba_users u
WHERE u.user_id=ash.user_id and ash.sample_time BETWEEN
to_date('17-DEC-2019 13:00:00','DD-MON-YYYY HH24:MI:SS') and
to_date('17-DEC-2019 13:50:10','DD-MON-YYYY HH24:MI:SS') and u.username ='USER' group by ash.SQL_ID order by 1;
count(*) SQL_ID
--------- -------------
1 sqlid1
100 sqlid2
2451
regards,
Paul
1