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

VIEW: SYS.KU$_10_2_IND_STATS_VIEW

Object Details
Object Name: KU$_10_2_IND_STATS_VIEW
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
VERS_MAJOR CHAR (1)
VERS_MINOR CHAR (1)
OBJ_NUM NUMBER

BASE_OBJ_NUM NUMBER

BASE_TAB_OBJ KU$_SCHEMAOBJ_T (2768)
BASE_IND_OBJ KU$_SCHEMAOBJ_T (2768)
TYPE_NUM NUMBER

PROPERTY NUMBER

COLS NUMBER

ROWCNT NUMBER

LEAFCNT NUMBER

DISTKEY NUMBER

LBLKKEY NUMBER

DBLKKEY NUMBER

CLUFAC NUMBER

BLEVEL NUMBER

IND_FLAGS NUMBER

OBJ_FLAGS NUMBER

SAMPLE_SIZE NUMBER

ANALYZETIME VARCHAR2 (19)
CACHE_INFO KU$_CACHED_STATS_T (96)
PARTITION_LIST KU$_PIND_STATS_LIST_T (64)
CNST_COL_LIST KU$_TAB_COL_LIST_T (64)
Query Text

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


SELECT VERS_MAJOR
,      VERS_MINOR
,      OBJ_NUM
,      BASE_OBJ_NUM
,      BASE_TAB_OBJ
,      BASE_IND_OBJ
,      TYPE_NUM
,      PROPERTY
,      COLS
,      ROWCNT
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      BLEVEL
,      IND_FLAGS
,      OBJ_FLAGS
,      SAMPLE_SIZE
,      ANALYZETIME
,      CACHE_INFO
,      PARTITION_LIST
,      CNST_COL_LIST
FROM SYS.KU$_10_2_IND_STATS_VIEW;

Dependencies

[top of page]

SYS.KU$_10_2_IND_STATS_VIEW references the following:

SchemaSYS
TableCOL$
PL/SQL PackageDBMS_METADATA_UTIL - show dependent code
TableIND$
TYPEKU$_11_2_IND_STATS_T
TYPEKU$_CACHED_STATS_T
ViewKU$_IND_CACHE_STATS_VIEW
ViewKU$_IND_COL_VIEW
TYPEKU$_PIND_STATS_LIST_T
ViewKU$_PIND_STATS_VIEW
TYPEKU$_SCHEMAOBJ_T
ViewKU$_SCHEMAOBJ_VIEW
TYPEKU$_SPIND_STATS_LIST_T
TYPEKU$_TAB_COL_LIST_T
TableOBJ$
ViewSESSION_ROLES
PL/SQL PackageSTANDARD - show dependent code

SYS.KU$_10_2_IND_STATS_VIEW is not referenced by any database object