Re: Determining current session execution

First identify that user through the v$session table. select sid, serial#, program
from v$session
where type = 'USER'
gets you all client sessions.
Then either use the sid to work with v$access (show all used objects) or v$open_cursor
or v$sqltext
to see what it is doing.
Or issue
exec dbms_system.set_sql_trace_in_session(<yoursid>,<yourserial>, true) to enable trace for this particular session onlu.

Hth,

--
Sybrand Bakker, Oracle DBA
Christophe Galerne <christophe_at_tumbleweed.com> wrote in message news:37FAB9AB.14D08FC1_at_tumbleweed.com...
> Guys,
>
> I have several processes that are connected to an Oracle Instance.
> One of those processes calls a stored procedure that takes for ever.
> I would like to know if there is a way to monitore what each Oracle
> session is doing to figure out which stored procedure is taking so long.
>
> One solution that I think of is to enable the SQL_TRACE facility then
> analyze the output but I guess there is a way to do what I want on the
> fly.
>
> Thanks,
> Christophe
>
> Christophe L. Galerne cgalerne_at_tumbleweed.com
> Software Engineer Tel: (650) 216 2029
Received on Tue Oct 05 1999 - 23:48:54 CDT