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 |
plsqlTopic
onsiteTopic