DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.SCHEDULER$_JOB_RUN_DETAILS

Object Details
Object Name: SCHEDULER$_JOB_RUN_DETAILS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: SCHEDULER$_JOB_RUN_DETAILS_PK
  1. ColumnLOG_ID
Indexes
Index Type Uniqueness Tablespace Column
I_SCHEDULER_JOB_RUN_DETAILS NORMAL NONUNIQUE TablespaceSYSAUX ColumnLOG_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableSCHEDULER$_JOB_OUTPUT SCHEDULER$_JOB_OUTPUT_FK SCHEDULER$_JOB_RUN_DETAILS SCHEDULER$_JOB_OUTPUT LOG_ID
Columns
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)
Query Text

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;

Dependencies

[top of page]

SYS.SCHEDULER$_JOB_RUN_DETAILS does not reference any database object

SYS.SCHEDULER$_JOB_RUN_DETAILS is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_JOB_RUN_DETAILS
ViewDBA_SCHEDULER_JOB_RUN_DETAILS
Package BodyDBMS_ISCHED - show dependent code
ViewUSER_SCHEDULER_JOB_RUN_DETAILS