RE: Chasing a session...

Not, unless you traced it. And then you would get this info from a trace
file, not from v$ views


  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Dhimant Patel
Sent: Thursday, August 24, 2006 6:39 PM
To: oracle-l
Subject: 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.

Other related posts: