Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Capturing all SQL_IDs for a SessionId

Re: Capturing all SQL_IDs for a SessionId

From: John Darrah <darrah.john_at_gmail.com>
Date: Thu, 26 Apr 2007 08:41:24 -0600
Message-ID: <ec40ac060704260741i4c743943mf1fab303a7fed899@mail.gmail.com>


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
>
> __________________________________________________
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 26 2007 - 09:41:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US