Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SCHEDULER_RUNNING_JOBS

ALL_SCHEDULER_RUNNING_JOBS displays information about the running Scheduler jobs accessible to the current user.

Related Views

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