RE: dbms_system.set

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 17 May 2007 17:52:39 -0700
Message-ID: <22EC50E60931494FA666A8CF8260C45B5D9D63@ALVMBXW05.prod.quest.corp>

Try v$process.spid

SQL> select a.sid, a.serial#, b.spid
2 from v$session a, v$process b
3 where a.paddr = b.addr ;

SID SERIAL# SPID
--------- --------- ------------

        1         1 9223
        2         1 9225
        3         1 9227
        4         1 9229
        5         1 9231
        6         1 9233
        7         1 9235
       21     19452 15424
        9         1 9243
       10         1 9245
       20      1149 15165
       15         3 9263

12 ligne(s) sélectionnée(s).
# ps -ef | grep oracle

...

oracle 9223 1 0 Mar 29 ? 0:08 ora_pmon_sdu2920a
oracle 9225 1 0 Mar 29 ? 0:36 ora_dbw0_sdu2920a
oracle 9227 1 0 Mar 29 ? 76:59 ora_lgwr_sdu2920a
oracle 9229 1 0 Mar 29 ? 0:36 ora_ckpt_sdu2920a
oracle 9231 1 0 Mar 29 ? 140:11 ora_smon_sdu2920a
oracle 9233 1 0 Mar 29 ? 0:01 ora_reco_sdu2920a
oracle 9235 1 0 Mar 29 ? 0:13 ora_cjq0_sdu2920a
oracle 9239 1 0 Mar 29 ? 0:00 ora_s000_sdu2920a
oracle 9241 1 0 Mar 29 ? 0:00 ora_d000_sdu2920a
oracle 9243 1 0 Mar 29 ? 0:01 ora_arc0_sdu2920a
oracle 9245 1 0 Mar 29 ? 0:00 ora_arc1_sdu2920a

oracle 15165 15164 0 Apr 06 ? 0:09 oraclesdu2920a (DESCRIPTION=(LOC) oracle 9263 1 0 Mar 29 ? 216:57 ora_qmn0_sdu2920a oracle 15424 1 0 17:44:23 ? 0:01 oraclesdu2920a (LOCAL=NO)
#

De : oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] De la part de sol beach Envoyé : jeudi, 17. mai 2007 10:42
À : joe_dba_at_hotmail.com
Cc : oracle-l_at_freelists.org
Objet : Re: dbms_system.set_ev

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

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

Received on Thu May 17 2007 - 19:52:39 CDT

RE: dbms_system.set_ev