Re: Checking SQL_TRACE status of a particular session
From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Thu, 24 Jan 2008 00:00:16 -0800
Message-ID: <47984590.8020009@ora-600.net>
Date: Thu, 24 Jan 2008 00:00:16 -0800
Message-ID: <47984590.8020009@ora-600.net>
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.
Regards,
Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net
Received on Thu Jan 24 2008 - 02:00:16 CST