AUDSID temporary not found [message #659415] |
Mon, 16 January 2017 04:36 |
Gogetter
Messages: 39 Registered: December 2009 Location: Cologne Germany
|
Member |
|
|
Hello all,
we have some long processes which we start with an external "Job Listener".
When a process starts it selects audsid and instance id from gv_$session and saves it in job-parameter-table.
After a given time - the "Job Listener" is checking the gv_$session whether the process is still running and if not it will generate mail to inform operator and set failure on process.
Select to Check running Job:
CURSOR cur_DBSessions (p_AUDSID IN NUMBER
,p_INSTANCE_ID IN NUMBER) IS
SELECT audsid
,inst_id
,module
,action
FROM sys.gv_$session
WHERE audsid = p_AUDSID
AND inst_id = p_INSTANCE_ID;
This works fine for many years. But now we upgrated to 12c in Oracle Cloud and sometimes the audsid temporary isn't found in the gv_$session view. Some seconds later audsid appears again.
Maybe gv_$session is only for the active sessions, and waitung sessions have an extra view?
Anyone has an Idea?
Thanks
Rudi
[Updated on: Mon, 16 January 2017 04:37] Report message to a moderator
|
|
|