How to identify the session inside Jobs

From: Giovanni Cuccu <gcuccu_at_dianoema.it>
Date: Mon, 07 Feb 2005 17:52:13 +0100
Message-ID: <42079CBD.8020207@dianoema.it>

Hi all,

        I have to monitor some session statistics (amount of redo log for example) and I setup a logofftrigger to do this. Inside the trigger I use sys_context('USERENV','SESSIONID') to identify the current session and to trace the stats on a table.
My main problem is that if the pl/sql code executes inside a job (DBMS_JOB) the trigger get always 0 as
sys_context('USERENV','SESSIONID') and I don't know hwo to identify the job session stats. Does anyone know how to determine sid, serial or whatever gives access to the session statistics from the session itself? Oracle 9.2.0.4 on AIX
Thanks in advance,

        Giovanni
--

---

Giovanni Cuccu
Sw Engineer_at_dianoema.it
Dianoema S.p.A.
Via de' Carracci 93 40131 Bologna
Tel: 051-7098211 051-4193911
e-mail:gcuccu_at_dianoema.it

---

No man does it all by himself,
I said young man,
put your pride on the shelf

---

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 07 2005 - 11:55:41 CST