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

TABLE: SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY

Object Details
Object Name: WRI$_OPTSTAT_HISTHEAD_HISTORY
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST FUNCTION-BASED NORMAL UNIQUE TablespaceSYSAUX ColumnSYS_EXTRACT_UTC("SAVTIME")
SYS_IL0001079371C00022$$ LOB UNIQUE Tablespace
I_WRI$_OPTSTAT_HH_ST FUNCTION-BASED NORMAL NONUNIQUE TablespaceSYSAUX ColumnSYS_EXTRACT_UTC("SAVTIME")
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
INTCOL# NUMBER
Yes
SAVTIME TIMESTAMP(6) WITH TIME ZONE (13)
FLAGS NUMBER

NULL_CNT NUMBER

MINIMUM NUMBER

MAXIMUM NUMBER

DISTCNT NUMBER

DENSITY NUMBER

LOWVAL RAW (1000)
HIVAL RAW (1000)
AVGCLN NUMBER

SAMPLE_DISTCNT NUMBER

SAMPLE_SIZE NUMBER

TIMESTAMP# DATE

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 VARCHAR2 (1000)
SPARE5 VARCHAR2 (1000)
SPARE6 TIMESTAMP(6) WITH TIME ZONE (13)
EXPRESSION CLOB (4000)
COLNAME VARCHAR2 (128)
SAVTIME_DATE DATE

Query Text

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


SELECT OBJ#
,      INTCOL#
,      SAVTIME
,      FLAGS
,      NULL_CNT
,      MINIMUM
,      MAXIMUM
,      DISTCNT
,      DENSITY
,      LOWVAL
,      HIVAL
,      AVGCLN
,      SAMPLE_DISTCNT
,      SAMPLE_SIZE
,      TIMESTAMP#
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      EXPRESSION
,      COLNAME
,      SAVTIME_DATE
FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY;

Dependencies

[top of page]

SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY does not reference any database object

SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY is referenced by following:

SchemaSYS
ViewALL_COL_PENDING_STATS
ViewDBA_COL_PENDING_STATS
Package BodyDBMS_STATS_INTERNAL - show dependent code
ViewUSER_COL_PENDING_STATS
View_user_stat