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

TABLE: SYS.SCHEDULER$_CONSTRAINTS_STATS

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: SCHEDULER$_CONST_STATS_PK
  1. ColumnOID
  2. ColumnRESOID
  3. ColumnJOBOID
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_CONST_STATS_PK NORMAL UNIQUE TablespaceSYSAUX ColumnOID
ColumnRESOID
ColumnJOBOID
I_SCHEDULER_CONST_STAT1 NORMAL NONUNIQUE TablespaceSYSAUX ColumnRESOID
I_SCHEDULER_CONST_STAT2 NORMAL NONUNIQUE TablespaceSYSAUX ColumnJOBOID
Columns
Name Datatype Length Mandatory Comments
OID NUMBER
Yes
RESOID NUMBER
Yes
JOBOID NUMBER
Yes
LAST_BLOCK TIMESTAMP(6) WITH TIME ZONE (13)
TOTAL_BLOCK_COUNT NUMBER

Query Text

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


SELECT OID
,      RESOID
,      JOBOID
,      LAST_BLOCK
,      TOTAL_BLOCK_COUNT
FROM SYS.SCHEDULER$_CONSTRAINTS_STATS;

Dependencies

[top of page]

SYS.SCHEDULER$_CONSTRAINTS_STATS does not reference any database object

SYS.SCHEDULER$_CONSTRAINTS_STATS is not referenced by any database object