Re: USERS_EXECUTING in V$SQLAREA

In article <f98999c8.0107060635.103c0c4b_at_posting.google.com>, jc_va_at_hotmail.com says...
>
>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.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:767025833873 for a script that does this -- It shows everyone logged in and if they are active, what they are doing and how long they've been doing it.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp