Re: Capturing all SQL_IDs for a SessionId

Thanks for replying.

I found another way by means of database logoff trigger, where I could query 
the v$open_cursor to get a list of sql_ids for that particular session. I could 
save just the sql_ids and/or sql_text for that session in another table. I also 
have control over which specific UserIds I want to do this collection for.

-Deepak


----- Original Message ----
From: John Darrah <darrah.john@xxxxxxxxx>
To: sharmakdeep_oracle@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Thursday, April 26, 2007 9:41:24 AM
Subject: Re: Capturing all SQL_IDs for a SessionId

v$active_session_history is as close as you will get without putting a 
sql_trace on the session.  It samples every second.


On 4/25/07, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> wrote: 
Is there a way to capture all the SQL_IDs that a session generated - 
historically?

I have tried a couple of options like v$open_cursor (it's volatile in the sense 
that entries exist as long as the session exist). 

v$active_session_history - Does only sampling and does not capture every sql.

Pls correct me if my above observations are wrong.

Thanks,
Deepak

__________________________________________________ 
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

Other related posts: