cancel
Showing results for 
Search instead for 
Did you mean: 

limit jobs per policy on Oracle policies

bills
Level 5

Hi:

NBU 6.5.5, RHEL 4.7 x64

I am trying to set the "limit jobs per policy" attribute in an Oracle policy contain ONLY Automatic schedules (application schedules are in another policy; the server side script changes the policy name and allocates streams accordingly, which works fine).  The limit, however, is not being honored.  The docs say that parent jobs do not count agains the number of jobs; are the automatic schedules considered parent jobs?

Thanks

Bill

3 REPLIES 3

bills
Level 5

Support says that the "automatic" schedule jobs are not considered parent jobs in the normal "parent-child" relationship (true parents jobs have dashes for the schedule in the activity monitor).  But, the limit jobs per policy option is meant as a resource limiter, and since the automatic jobs don't use any resources, the limit is not applied.

Anton_Panyushki
Level 6
Certified

The number of jobs depends on PARALLELISM parameter in our RMAN script.

Have a look at the following excerpt .

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM $DB_PARALLELISM;$CONF_DB_DEVICE

bills
Level 5

Thanks for the comment, Anton.  I know the DBAs are specifying multiple streams in their scripts, although I don't see the PARALLELISM keyword.  Those affect the application backup jobs, though - I'm trying to limit the automatic jobs - the ones that run the rman script.

Bill