| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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_at_yahoo.com> 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
 |
 |