DBMS_SCHEDULER ALLOW_RUNS_IN_RESTRICTED_MODE Attribute Does Not Work
(Doc ID 968794.1)
Last updated on APRIL 06, 2022
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Prior to 11g running jobs (either via dbms_scheduler or dbms_jobs) in restricted mode was not possible because an instance started in Restrict Session mode will not allow any secondary process such as job processes to start.
See <Note.313102.1> "Jobs Not Executing Automatically".
In 11g a new feature was introduced to allow jobs to run in restricted session by setting "ALLOW_RUNS_IN_RESTRICTED_MODE" attribute for the job. This was introduced via Enhancement <Bug 5921319>.
So with "ALLOW_RUNS_IN_RESTRICTED_MODE" set, a job should be able to run while instance is in restricted mode.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document