Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

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

Go to previous page
Go to next page
View PDF


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