Re: dbms_system.set_ev

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: sol.beach@xxxxxxxxx
  • Date: Thu, 17 May 2007 15:24:59 -0600

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: