Chasing a session...

Gurus,

Is there a straight way of querying v$SQL* views in order to retrieve all queries made by a session
including a recursive queries made by oracle on behalf of user. Assume that SID and SERIAL# are known for the session.

I could not think of any other ways but tracing a session and then use TKPROF, which is not always possible and/or desirable.

Thanks for advice -
DP.

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