OWNER |
VARCHAR2(30) |
|
Owner of the running Scheduler job |
JOB_NAME |
VARCHAR2(30) |
|
Name of the running Scheduler job |
JOB_SUBNAME |
VARCHAR2(30) |
|
Subname of the running Scheduler job (for a job running a chain step) |
JOB_STYLE |
VARCHAR2(11) |
|
Job style:
-
REGULAR
-
LIGHTWEIGHT
-
VOLATILE
|
DETACHED |
VARCHAR2(5) |
|
Indicates whether the detached attribute is set for the job (TRUE) or not (FALSE). If the detached attribute is set, then the job will remain running even after the job action has completed. |
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 |
INTERVAL DAY(3) TO SECOND(2) |
|
CPU time consumed by the running Scheduler job, if available |
DESTINATION_OWNER |
VARCHAR2(128) |
|
Owner of the destination object (if used), else NULL |
DESTINATION |
VARCHAR2(128) |
|
Destination that this job is running on |
CREDENTIAL_OWNER |
VARCHAR2(30) |
|
Owner of the login credential used for this running job, if any |
CREDENTIAL_NAME |
VARCHAR2(30) |
|
Name of the login credential used for this running job, if any |
