RE: dbms_system.set_ev
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <sol.beach@xxxxxxxxx>, <joe_dba@xxxxxxxxxxx>
- Date: Thu, 17 May 2007 17:52:39 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] De la
part de sol beach
Envoyé : jeudi, 17. mai 2007 10:42
À : joe_dba@xxxxxxxxxxx
Cc : oracle-l@xxxxxxxxxxxxx
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@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
Other related posts:
