Re: dbms_system.set_ev

  • From: "Joe Smith" <joe_dba@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 17 May 2007 14:16:02 -0500

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

--
//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 

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2007