[Home] [Help]
[Dependency Information]
VIEW: SYS.KU$_10_1_PTAB_STATS_VIEW
Object Details
Object Name: | KU$_10_1_PTAB_STATS_VIEW |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ_NUM |
NUMBER |
|
|
|
TRIGFLAG |
NUMBER |
|
|
|
SCHEMA_OBJ |
KU$_SCHEMAOBJ_T |
(2768) |
|
|
BOBJ_NUM |
NUMBER |
|
|
|
SYSGEN_COLS |
NUMBER |
|
|
|
BLKCNT |
NUMBER |
|
|
|
ROWCNT |
NUMBER |
|
|
|
AVGRLN |
NUMBER |
|
|
|
FLAGS |
NUMBER |
|
|
|
CACHE_INFO |
KU$_CACHED_STATS_T |
(96) |
|
|
COL_STATS |
KU$_10_1_COL_STATS_LIST_T |
(64) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ_NUM
, TRIGFLAG
, SCHEMA_OBJ
, BOBJ_NUM
, SYSGEN_COLS
, BLKCNT
, ROWCNT
, AVGRLN
, FLAGS
, CACHE_INFO
, COL_STATS
FROM SYS.KU$_10_1_PTAB_STATS_VIEW;
Dependencies
[top of page]
SYS.KU$_10_1_PTAB_STATS_VIEW references the following:
-
SYS
-
ASSOCIATION$
-
COLTYPE$
-
DBMS_METADATA_UTIL
- show dependent code
-
KU$_10_1_COL_STATS_LIST_T
-
KU$_10_1_PTAB_COL_STATS_VIEW
-
KU$_10_1_TAB_PTAB_STATS_T
-
KU$_CACHED_STATS_T
-
KU$_HISTGRM_LIST_T
-
KU$_SCHEMAOBJ_T
-
KU$_SCHEMAOBJ_VIEW
-
KU$_TAB_CACHE_STATS_VIEW
-
OBJ$
-
STANDARD
- show dependent code
-
TAB$
-
TABCOMPART$
-
TABPART$
-
TABSUBPART$
-
UTL_RAW
- show dependent code
SYS.KU$_10_1_PTAB_STATS_VIEW is referenced by following:
-
SYS
-
KU$_10_1_TAB_STATS_VIEW