RE: No data in the sql_address column of v$session

Arun

>But when u are waiting on a latch free on shared pool
>dont u think there should be an sql_address to it.
>When a session is active, in the sense that he has a
>transaction then i thought he should have an
>sql_addresss, but based on the below information u can
>see that there is no sql_address nor hash value.
>this is what is bugging me

Not all operations performed in Oracle are based on SQL statements. Even a COMMIT or ROLLBACK has no entry in V$SQL... Therefore, sql_address contains an address only when there's something to reference in V$SQL (or similar views...).

HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com

Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Hamburg (13-Oct), München (20-Oct), Basel (25-Oct), Frankfurt (27-Oct), 
         Zürich (29-Nov), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec)

--
http://www.freelists.org/webpage/oracle-l