From: "Robert Fazio" <rfazio@home.com.nospam>
Newsgroups: comp.databases.oracle.server
References: <f98999c8.0107060635.103c0c4b@posting.google.com>
Subject: Re: USERS_EXECUTING in V$SQLAREA
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <CrN17.4230$Y6.1345047@news1.rdc2.pa.home.com>
Date: Sun, 08 Jul 2001 00:03:46 GMT
NNTP-Posting-Host: 24.8.218.197
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc2.pa.home.com 994550626 24.8.218.197 (Sat, 07 Jul 2001 17:03:46 PDT)
NNTP-Posting-Date: Sat, 07 Jul 2001 17:03:46 PDT
Organization: Excite@Home - The Leader in Broadband http://home.com/faster


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@hotmail.com> wrote in message
news:f98999c8.0107060635.103c0c4b@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.