ALL_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs accessible to the current user.
DBA_SCHEDULER_RUNNING_JOBS displays information about all running Scheduler jobs in the database.
USER_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the running Scheduler job |
JOB_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the running Scheduler job |
JOB_SUBNAME |
VARCHAR2(30) |
Subname of the running Scheduler job | |
SESSION_ID |
NUMBER |
Identifier of the session running the Scheduler job | |
SLAVE_PROCESS_ID |
NUMBER |
Process number of the slave process running the Scheduler job | |
SLAVE_OS_PROCESS_ID |
VARCHAR2(12) |
Process number of the operating system slave process running the scheduler job | |
RUNNING_INSTANCE |
NUMBER |
Database instance number of the slave process running the Scheduler job | |
RESOURCE_CONSUMER_GROUP |
VARCHAR2(32) |
Resource consumer group of the session in which the Scheduler job is running | |
ELAPSED_TIME |
INTERVAL DAY(3) TO SECOND(2) |
Elapsed time since the Scheduler job was started | |
CPU_USED |
NUMBER |
Scheduler job CPU time consumed, if available |