rs_queue_schedulers

on-site-related topic

The following table lists the columns for the rs_queue_schedulers view. The equivalent jcs_queue_schedulers view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.

Column Datatype Description
QUEUE_PARTITION VARCHAR2 The partition of a Queue
QUEUE_NAME VARCHAR2 The name of a Queue
SCHEDULER_PARTITION VARCHAR2 The partition of a scheduler
SCHEDULER_NAME VARCHAR2 The name of a scheduler
STATUS VARCHAR2 The status of a Queue: O=open, C=closed
EXECUTION_SIZE NUMBER The number of concurrent jobs in the Queue
HOLD VARCHAR2 Is this Queue-scheduler disabled? (Y or N)
HOLD_LEVEL NUMBER In the Queue, jobs having a priority below the specified number will not be started
HOLD_ABOVE_CPU_LOAD NUMBER In the Queue, no jobs will be started when the CPU load exceeds the specified level
HOLD_ABOVE_PAGE_RATE NUMBER In the Queue, no jobs will be started when the memory paging rate exceeds the specified level
TIME_WINDOW_PARTITION VARCHAR2 The partition of the Time Window of the Queue
TIME_WINDOW_NAME VARCHAR2 The name of the Time Window of the Queue
NEXT_WINDOW_CHANGE TIMESTAMP WITH TIME ZONE The next date on which the Time Window will open or close the Queue againThe timezone is specified as an Olson name.
STATUS_DESCRIPTION VARCHAR2 The description of the Queue status
RUNNING_JOBS NUMBER Current number of running jobs for this Queue scheduler
INCLUSIVE VARCHAR2 If true, the Queue size includes waiting jobs
TIMEZONE_NAME VARCHAR2 The timezone for this Queue scheduler