Configuring Job Throttling for an Oracle Client

By default, the maximum number of data and log jobs will each be set to 1, when job throttling is enabled for the client.

By default, the jobs targeted for immediate execution are not excluded from job throttling. All RMAN application command line jobs are immediate jobs. However, you can exclude immediate jobs from job throttling. This is useful when the administrator wants to run a backup immediately without waiting for the queue to clear even when the job limits have been reached on the client. In this case, only scheduled jobs are throttled.

See Command Line - Syntax.

Procedure

  1. Check the current job throttling settings for a client.

    qoperation execscript -sn SetLimitRunningJobs -si 'client' -si 'View'

  2. Set the job throttling option.

    Run the following command to enable job throttling for a client:

    qoperation execscript -sn SetLimitRunningJobs -si 'client' -si 'LimitJobs' -si 1

    Run the following command to disable job throttling for a client:

    qoperation execscript -sn SetLimitRunningJobs -si 'client' -si 'LimitJobs' -si 0

  3. Run the following command to exclude jobs targeted for immediate execution from being throttled:

    qoperation execscript -sn SetLimitRunningJobs -si 'client' -si 'Exclude' -si 1

  4. Run the following command to enforce throttling for all the jobs including the jobs targeted for immediate execution:

    qoperation execscript -sn SetLimitRunningJobs -si 'client' -si 'Exclude' -si 0