8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1)


Mor said...

Hi,

You listed ADDITIONAL_INFO as a new column in 12c, but it already existed in dba/all/user_scheduler_job_run_details from at least version 10.2:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2048.htm#REFRN20386

Regards,
Mor

Tim... said...

Hi.

You are correct. I even use that column in some of my older scheduler articles. :) I've removed it.

Thanks for the heads-up.

Cheers

Tim...

Patrick Jolliffe said...

Tim,
With regards to mutlitennant and scheduler, you might want to be aware of MOS DOCId 2175443.1.
I have blogged about it here:
https://hkpatora.com/2017/03/30/do-not-set-job_queue_processes-at-pdb-level-in-12-1-0-2/
Regards
Patrick

Tim... said...

Hi.

Thanks for the heads-up. I've added an extra sentence to the existing bullet point, with a link to the MOS note and a shout out to your blog post. :)

Cheers

Tim...

Patrick Jolliffe said...

Appreciated. By the way, I have updated blog post to include a test case.
Of particular concern is that it allows local user with DBA privilege on one PDB to break scheduler jobs in other PDBs.
Regards
Patrick

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.