Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Capturing all SQL_IDs for a SessionId
dbms_monitor.session_trace_enable might work or fill the filesystem .
What problem are you trying to solve?
On 4/26/07, John Darrah <darrah.john_at_gmail.com> wrote:
> 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
> >
> >
> >
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 26 2007 - 11:17:25 CDT
![]() |
![]() |