Forum Discussion

bills's avatar
bills
Level 5
15 years ago

limit jobs per policy on Oracle policies

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

  • 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.

  • 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

  • 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