Database Administration (MOSC)

MOSC Banner

Discussions

sql_id is not in v$session

edited Mar 1, 2024 3:38PM in Database Administration (MOSC) 9 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center