Re: Checking SQL_TRACE status of a particular session

From: Jeremiah Wilton <>
Date: Thu, 24 Jan 2008 00:00:16 -0800
Message-ID: <>

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.


Jeremiah Wilton
ORA-600 Consulting Received on Thu Jan 24 2008 - 02:00:16 CST

Original text of this message