Re: Checking SQL_TRACE status of a particular session

From: Steve Howard <>
Date: Thu, 24 Jan 2008 06:48:16 -0800 (PST)
Message-ID: <>

On Jan 24, 3:23 am, Peter Teoh <> wrote:
> Thanks, after some digging, read_ev() can be used for the current
> session. But if I would like to check on ALL THE SESSION, then there
> seemed no way:
> Thanks.

I am sure there is a more elegant way with oradebug, or something similar. However, you could always read each spid in v$process and check for a corresponding trace file in udump.

set serveroutput on size 1000000
  l_udump varchar2(300);
  select value
    into l_udump
    from v$parameter
    where name = 'user_dump_dest';
  for cur in (select spid

                from v$process p,
                     v$session s
                where s.paddr = p.addr) loop
    dbms_output.put_line('ls -lrt ' || l_udump || '/*' || cur.spid || '*');
  end loop;
/ Received on Thu Jan 24 2008 - 08:48:16 CST

Original text of this message