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


TABLE: SYS.DIR$QUIESCE_OPERATIONS

Object Details
Object Name: DIR$QUIESCE_OPERATIONS
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_DIR$QUIESCE_UI NORMAL UNIQUE TablespaceSYSAUX ColumnJOB_NAME
ColumnSTATUS
I_DIR$QUIESCE_ALERT_SEQ_ID NORMAL NONUNIQUE TablespaceSYSAUX ColumnALERT_SEQ_ID
I_DIR$QUIESCE_END_TIME NORMAL NONUNIQUE TablespaceSYSAUX ColumnEND_TIME
I_DIR$QUIESCE_STATUS NORMAL NONUNIQUE TablespaceSYSAUX ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
JOB_NAME VARCHAR2 (100)
ALERT_SEQ_ID NUMBER

JOB_TYPE NUMBER

INCARNATION_INFO VARCHAR2 (4000)
INSTANCE_NAME VARCHAR2 (4000)
SUBMIT_TIME DATE

STATUS NUMBER

START_TIME DATE

END_TIME DATE

ERROR_MESSAGE VARCHAR2 (4000)
SPAREN1 NUMBER

SPAREN2 NUMBER

SPAREN3 NUMBER

SPAREN4 NUMBER

SPAREN5 NUMBER

SPAREVC1 VARCHAR2 (4000)
SPAREVC2 VARCHAR2 (4000)
SPAREVC3 VARCHAR2 (4000)
SPAREVC4 VARCHAR2 (4000)
SPAREVC5 VARCHAR2 (4000)
Query Text

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


SELECT JOB_NAME
,      ALERT_SEQ_ID
,      JOB_TYPE
,      INCARNATION_INFO
,      INSTANCE_NAME
,      SUBMIT_TIME
,      STATUS
,      START_TIME
,      END_TIME
,      ERROR_MESSAGE
,      SPAREN1
,      SPAREN2
,      SPAREN3
,      SPAREN4
,      SPAREN5
,      SPAREVC1
,      SPAREVC2
,      SPAREVC3
,      SPAREVC4
,      SPAREVC5
FROM SYS.DIR$QUIESCE_OPERATIONS;

Dependencies

[top of page]

SYS.DIR$QUIESCE_OPERATIONS does not reference any database object

SYS.DIR$QUIESCE_OPERATIONS is not referenced by any database object