Re: How to detect which session is being trace?

"Jeffrey Yee" <jeffyee_at_hotmail.com> wrote in message news:ec4cec95.0312050148.2d968f86_at_posting.google.com...
> Hi,
>
> I recently come to realise that there are lots of trace file in the
> udump directory. Even when the SQL_TRACE is set to FALSE in the
> init.ora file, I realise that some user can change their session
> sql_trace to true.
>
> Is there any way I can detect what session is being trace? Also, may I
> know what privilege is needed to allow user to issue 'alter session'
> or 'alter system'.
>
> I beleive there is also some dbms package to allow user to set trace.
> I wonder what privilege does a user needs to issue this package call.
>
> Please do advice. Thank you.
>
> Best Regards,
> Jeffrey Yee

Just make sure you are not confusing system error dumps with regular trace files. Look in alert log also.

Now "alter session" priv is needed to issue an "alter session" command (Never mind how obvious this sounds :)

dbms_system package can be used to issue a trace too.

Now the trace file generated would have the spid somewhere in its name .. Find out what session it refers to from v$session + v$process.

Anurag Received on Fri Dec 05 2003 - 08:28:08 CST