[Home] [Help] [Dependency Information]
Object Name: | SCHEDULER$_JOB_RUN_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SCHEDULER_JOB_RUN_DETAILS | NORMAL | NONUNIQUE | SYSAUX | LOG_ID |
Table | |
Foreign Table | Foreign Key Column | SCHEDULER$_JOB_OUTPUT | SCHEDULER$_JOB_RUN_DETAILS | SCHEDULER$_JOB_OUTPUT LOG_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_ID | NUMBER | Yes | ||
LOG_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
REQ_START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
RUN_DURATION | INTERVAL DAY(3) TO SECOND(0) | (11) | ||
INSTANCE_ID | NUMBER | |||
SESSION_ID | VARCHAR2 | (128) | ||
SLAVE_PID | VARCHAR2 | (30) | ||
CPU_USED | INTERVAL DAY(3) TO SECOND(2) | (11) | ||
ERROR# | NUMBER | |||
ADDITIONAL_INFO | VARCHAR2 | (4000) | ||
CREDENTIAL | VARCHAR2 | (261) | ||
DESTINATION | VARCHAR2 | (128) |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_ID
, LOG_DATE
, REQ_START_DATE
, START_DATE
, RUN_DURATION
, INSTANCE_ID
, SESSION_ID
, SLAVE_PID
, CPU_USED
, ERROR#
, ADDITIONAL_INFO
, CREDENTIAL
, DESTINATION
FROM SYS.SCHEDULER$_JOB_RUN_DETAILS;
SYS.SCHEDULER$_JOB_RUN_DETAILS does not reference any database object
SYS.SCHEDULER$_JOB_RUN_DETAILS is referenced by following:
|
|
|