How to detect which session is being trace?

From: Jeffrey Yee <jeffyee_at_hotmail.com>
Date: 5 Dec 2003 01:48:07 -0800
Message-ID: <ec4cec95.0312050148.2d968f86@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 Received on Fri Dec 05 2003 - 03:48:07 CST