rs_scheduler_queues
The following table lists the columns for the rs_scheduler_queues view. The equivalent jcs_scheduler_queues 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 |
SCHEDULER_PARTITION | VARCHAR2 | The partition of a scheduler |
SCHEDULER_NAME | VARCHAR2 | The name of a scheduler |
QUEUE_PARTITION | VARCHAR2 | The partition of a Queue |
QUEUE_NAME | VARCHAR2 | The name of a Queue |
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 scheduler Queue |
INCLUSIVE | VARCHAR2 | If true, the Queue size includes waiting jobs |
TIMEZONE_NAME | VARCHAR2 | The timezone for this scheduler Queue |