Re: dbms_system.set

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 17 May 2007 15:24:59 -0600
Message-Id: <20070517212415.ABDC36E386A@turing.freelists.org>

select p.spid "process",
from v$session s,

v$process p
where s.paddr = p.addr
and s.sid = <SID>

At 11:41 AM 5/17/2007, sol beach wrote:
>Alternatively, how would one obtain the process_ID# that becomes
>part of the trace file name?
>
>On 5/17/07, Joe Smith
><<mailto:joe_dba_at_hotmail.com>joe_dba_at_hotmail.com> wrote:
>Is there a way to name the trace file with dbms_system.set_ev();:

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 17 2007 - 16:24:59 CDT

Re: dbms_system.set_ev