RE: Chasing a session...

From: <tim_at_evdbt.com>
Date: Thu, 24 Aug 2006 11:35:55 -0400
Message-Id: <20060824153103.M88103@evdbt.com>

Depending on how the application is written, then V$OPEN_CURSOR might provide what you are looking for -- a "history" of SQL statements executed by a session.  However, it is at best only the most primitive of logging for that purpose, and if the application takes care to close unused cursors, it will be a misleadingly incomplete history.  So, you almost have to hope for a sloppily written application, which is sadly not too much to hope for... :-)

Just an idea...

On Thu, 24 Aug 2006 19:24:13 +0400, Vadim Bobrov wrote
> 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:35:55 CDT