| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |
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 | |
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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
