[Home] [Help] [Dependency Information]
Object Name: | KU$_TAB_ONLY_STATS_VIEW |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ_NUM | NUMBER | |||
TRIGFLAG | NUMBER | |||
TABNAME | VARCHAR2 | (128) | ||
PARTNAME | VARCHAR2 | (0) | ||
SUBPARTNAME | VARCHAR2 | (0) | ||
BOBJ_NUM | NUMBER | (1) | ||
SYSGEN_COLS | NUMBER | |||
BLKCNT | NUMBER | |||
ROWCNT | NUMBER | |||
AVGRLN | NUMBER | |||
FLAGS | NUMBER | |||
SAMPLE_SIZE | NUMBER | |||
ANALYZETIME | VARCHAR2 | (19) | ||
CACHE_INFO | KU$_CACHED_STATS_T | (96) | ||
COL_STATS | KU$_COL_STATS_LIST_T | (64) |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ_NUM
, TRIGFLAG
, TABNAME
, PARTNAME
, SUBPARTNAME
, BOBJ_NUM
, SYSGEN_COLS
, BLKCNT
, ROWCNT
, AVGRLN
, FLAGS
, SAMPLE_SIZE
, ANALYZETIME
, CACHE_INFO
, COL_STATS
FROM SYS.KU$_TAB_ONLY_STATS_VIEW;
|
|
|