Re: USERS_EXECUTING in V$SQLAREA

Once it connects get the sid and serial#

exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,true/false);

This is equivalent to:
alter session set sql_trace = true;
inside of the session;

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:f98999c8.0107060635.103c0c4b_at_posting.google.com...
> I want to monitor the progress of a 3rd party tool that is running SQL
> against a database. It doesn't do any logging until the process
> finishes.
>
> Is looking in V$SQLAREA for "USERS_EXECUTING = 1" a reasonable way of
> determining what is actually happening in the DB at any given time?
>
> The only other way that I've come up with is ORDER BY FIRST_LOAD_TIME
> DESC, but that can be misleading due to reuse of cursors.
>
> Thank you for any advice.
Received on Sat Jul 07 2001 - 19:03:46 CDT