Re: dbms_system.set_ev

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 17 May 2007 14:16:02 -0500
Message-ID: <BAY133-F20A837FE430A43F529A9E597330@phx.gbl>

You join v$session and v$process and get the spid. That is the process id on the trace file name.

>Alternatively, how would one obtain the process_ID# that becomes part of
>the
>trace file name?
>
>On 5/17/07, Joe Smith <joe_dba_at_hotmail.com> wrote:
>>
>>Is there a way to name the trace file with dbms_system.set_ev();:
>>
>>sys.dbms_system.set_ev();
>>
>>I have a login trigger that does:
>>
>>sys.dbms_system.set_ev(l_sid,l_serial#,10046,l_level,'');
>>
>>but I need to name the trace file and can this be done with
>>dbms_system.set_ev ?
>>
>>thanks.
>>
>>_________________________________________________________________
>>Catch suspicious messages before you open them—with Windows Live Hotmail.
>>
>>http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_protection_0507
>>
>>--
>>http://www.freelists.org/webpage/oracle-l
>>
>>
>>

---

PC Magazine’s 2007 editors’ choice for best Web mail—award-winning Windows Live Hotmail.
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507

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

Received on Thu May 17 2007 - 14:16:02 CDT