Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to identify the session inside Jobs

RE: How to identify the session inside Jobs

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 7 Feb 2005 21:45:10 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A01E6B4C6@MSXVS02.trivadis.com>


Ciao Giovanni

Eventually v$mystat contains the information you are looking for... If = it is the case, you don't need to know the sid/serial pair.

Ti auguro una buona giornata,
Chris

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Giovanni
>Cuccu
>Sent: 07 February 2005 17:52
>To: Oracle-l
>Subject: How to identify the session inside Jobs
>
>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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 07 2005 - 15:47:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US