Re: Checking SQL_TRACE status of a particular session
Date: Thu, 24 Jan 2008 00:00:16 -0800
Peter Teoh wrote:
> In 10g V$SESSION has a SQL_TRACE column to indicate if this session is
> traced or not.
> How about 9i and 8i? I cannot find such column.
I think you are looking for dbms_system.read_ev(). There are lots of examples out there on the web. SQL Trace is event 10046.
http://www.ora-600.net Received on Thu Jan 24 2008 - 02:00:16 CST