Re: dbms_system.set_ev

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@xxxxxxxxxxx>joe_dba@xxxxxxxxxxx> 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 ______________________________________________________________________

Other related posts: