RE: Chasing a session...

From: Vadim Bobrov <vadimbobrov_at_gmail.com>
Date: Thu, 24 Aug 2006 19:24:13 +0400
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAALfInlLIKt5BvFMVgTrLO6iChwAAEAAAADQWyLGMYvZIh96tG6IWQEYBAAAAAA==@gmail.com>

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.

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

Received on Thu Aug 24 2006 - 10:24:13 CDT