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 Corporationwww.centrexcc.com
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System.For more information please visit http://www.messagelabs.com/email ______________________________________________________________________