Home » SQL & PL/SQL » SQL & PL/SQL » AUDSID temporary not found (12C (PDB))
AUDSID temporary not found [message #659415] Mon, 16 January 2017 04:36
Messages: 37
Registered: December 2009
Location: Cologne Germany
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
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?


[Updated on: Mon, 16 January 2017 04:37]

Report message to a moderator

Previous Topic: Regarding Hints
Next Topic: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
Goto Forum:

Current Time: Tue Jul 27 20:53:36 CDT 2021