"Dexter" <vikram_ramakrishnan_at_ieee.org> wrote in message
news:1105245560.562421.28890_at_c13g2000cwb.googlegroups.com...
> Hi,
>
> how do i find if an oracle session is being traced?.
> If i have lot of sessions running in parallel and want to find all the
> session that are running 10046 level4 trace.how do i do it.
> any help or pointers would be helpuful.
>
> -Thanks,
> Vikram
>
One way i can think of is the tracefiles are created in user_dump_directory
with spid as part of the filename.
You can use this information to do a ls on the directory to see if the
tracefiles are being created for that session(s).
v$parmeter , v$session and v$process selects required.
Received on Sun Jan 09 2005 - 01:16:20 CST
