While running the job, this context information can be retrieved with SYS _CONTEXT(). That worked well for years. But lately we sometimes observe that SYS _CONTEXT() retrieves no data.
We found out, that with prestarting a scheduled job with TOAD's execute button the context information gets lost too. But we don't do that on production where we see that sometimes at night.
Does Oracle on its own do something like a rescheduling that is cleaning up the context of a job?
Greetings, Peter
-- ---- ---- ---- ---- ---- ----- Telefonieren Sie ohne weitere Kosten mit Ihren Freunden von PC zu PC! Jetzt Yahoo! Messenger installieren! <div>Dear list,</div> <div> </div> <div>we have some PL/SQL procesdures that submit jobs to our 8i database. And we have a logon trigger that sets an application context like this: </div> <div><FONT size=2> </div> <div >dbms_session</FONT><FONT color=#0000f0 size=2>.</FONT><FONT size=2>set_context< /FONT><FONT color=#0000f0 size=2>(</FONT><FONT color=#ff0000 size=2>'BENUTZER'< /FONT><FONT color=#0000f0 size=2>,</FONT><FONT size=2> </FONT><FONT color= #ff0000 size=2>'BENUTZ_ID'</FONT><FONT color=#0000f0 size=2>,</FONT><FONT size=2 > v_benutz_id</FONT><FONT color=#0000f0 size=2>);</FONT></div> <div><FONT color =#0000f0 size=2></FONT> </div> <div><FONT color=#0000f0 size=2>While running the job, this context information can be retrieved with SYS_CONTEXT(). That worked well for years. But lately we sometimes observe that SYS_CONTEXT() retrieves no data. </FONT></div> <div><FONT color=#0000f0></FONT> </div> <div><FONT color=#0000f0>We found out, that with pre starting a scheduled job with TOAD's execute button the context information gets lost too. But we don't do that on production where we see that sometimes at night.< /FONT></div> <div><FONT color=#0000f0></FONT> </div> <div><FONT color= #0000f0>Does Oracle on its own do something like a rescheduling that is cleaning up the context of a job?</FONT></div> <div><FONT color=#0000f0></FONT> < /div> <div><FONT color=#0000f0>Greetings, Peter</FONT></div> <div><FONT color= #0000f0></FONT> </div> <div><FONT color=#0000f0 size=2> </div></FONT> <p> <hr size=1>Telefonieren Sie ohne weitere Kosten mit Ihren Freunden von PC zu PC!<br>Jetzt <a href=http://de.messenger.yahoo.com>Yahoo! Messenger</a> installieren!
