Discussions
sql_id is not in v$session
Hi,
On 11.2.0.4 on AIX
A query that I know its sql_id is executed by user system every 5 minutes on database.
But any time I qury v$session:
select * from v$session where sql_id = 'aesrzt';
I have :
no rows selected
In an AWR for two hours I see it executed 25 times:
Any explanation?
Thank you.
0