|AUDSID temporary not found [message #659415]
||Mon, 16 January 2017 04:36
Registered: December 2009
Location: Cologne Germany
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
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?
[Updated on: Mon, 16 January 2017 04:37]
Report message to a moderator