RE: Chasing a session...
- From: "Vadim Bobrov" <vadimbobrov@xxxxxxxxx>
- To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Aug 2006 19:24:13 +0400
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:
