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


TABLE: SYS.SCHEDULER$_WINDOW_DETAILS

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SCHEDULER_WINDOW_DETAILS NORMAL NONUNIQUE TablespaceSYSAUX ColumnLOG_ID
Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER

LOG_DATE TIMESTAMP(6) WITH TIME ZONE (13)
INSTANCE_ID NUMBER

REQ_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
DURATION INTERVAL DAY(3) TO SECOND(0) (11)
ACTUAL_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
ADDITIONAL_INFO VARCHAR2 (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOG_ID
,      LOG_DATE
,      INSTANCE_ID
,      REQ_START_DATE
,      START_DATE
,      DURATION
,      ACTUAL_DURATION
,      ADDITIONAL_INFO
FROM SYS.SCHEDULER$_WINDOW_DETAILS;

Dependencies

[top of page]

SYS.SCHEDULER$_WINDOW_DETAILS does not reference any database object

SYS.SCHEDULER$_WINDOW_DETAILS is referenced by following:

SchemaSYS
ViewDBA_SCHEDULER_WINDOW_DETAILS
Package BodyDBMS_ISCHED - show dependent code