[Home] [Help] [Dependency Information]
Object Name: | DBA_SCHEDULER_RUNNING_JOBS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Owner of the running scheduler job | |
JOB_NAME | VARCHAR2 | (128) | Name of the running scheduler job | |
JOB_SUBNAME | VARCHAR2 | (128) | Subname of the running scheduler job (for a job running a chain step) | |
JOB_STYLE | VARCHAR2 | (17) | Job style - regular, lightweight or volatile | |
DETACHED | VARCHAR2 | (5) | ||
SESSION_ID | NUMBER | |||
SLAVE_PROCESS_ID | NUMBER | Process number of the slave process running the scheduler job | ||
SLAVE_OS_PROCESS_ID | VARCHAR2 | (12) | Operating system 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) | (11) | Time elapsed since the scheduler job started | |
CPU_USED | INTERVAL DAY(3) TO SECOND(2) | (11) | CPU time used by the running scheduler job, if available | |
DESTINATION_OWNER | VARCHAR2 | (128) | Owner of destination object (if used) else NULL | |
DESTINATION | VARCHAR2 | (128) | Destination that this job is running on | |
CREDENTIAL_OWNER | VARCHAR2 | (128) | Owner of login credential used for this running job, if any | |
CREDENTIAL_NAME | VARCHAR2 | (128) | Name of login credential used for this running job, if any | |
LOG_ID | NUMBER | Log id that will be used for this job run |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, JOB_NAME
, JOB_SUBNAME
, JOB_STYLE
, DETACHED
, SESSION_ID
, SLAVE_PROCESS_ID
, SLAVE_OS_PROCESS_ID
, RUNNING_INSTANCE
, RESOURCE_CONSUMER_GROUP
, ELAPSED_TIME
, CPU_USED
, DESTINATION_OWNER
, DESTINATION
, CREDENTIAL_OWNER
, CREDENTIAL_NAME
, LOG_ID
FROM SYS.DBA_SCHEDULER_RUNNING_JOBS;
|
|
|