Re: How to detect which session is being trace?

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 07 Dec 2003 15:48:51 -0800
Message-ID: <D%OAb.70031$kl6.6217@fed1read03>

Jeffrey Yee wrote:

> 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

At least on Solaris the filename of the trace file contains the Unix Process ID (PID) of the process that has requested the trace file to be generated. So with a Small Matter Of Programming, you should be able to determine who is the "culprit". Received on Sun Dec 07 2003 - 17:48:51 CST