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

VIEW: SYS.CDB_TAB_STATISTICS

Object Details
Object Name: CDB_TAB_STATISTICS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Optimizer statistics for all tables in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
Owner of the object
TABLE_NAME VARCHAR2 (30)
Name of the table
PARTITION_NAME VARCHAR2 (30)
Name of the partition
PARTITION_POSITION NUMBER

Position of the partition within table
SUBPARTITION_NAME VARCHAR2 (30)
Name of the subpartition
SUBPARTITION_POSITION NUMBER

Position of the subpartition within partition
OBJECT_TYPE VARCHAR2 (12)
Type of the object (TABLE, PARTITION, SUBPARTITION)
NUM_ROWS NUMBER

The number of rows in the object
BLOCKS NUMBER

The number of used blocks in the object
EMPTY_BLOCKS NUMBER

The number of empty blocks in the object
AVG_SPACE NUMBER

The average available free space in the object
CHAIN_CNT NUMBER

The number of chained rows in the object
AVG_ROW_LEN NUMBER

The average row length, including row overhead
AVG_SPACE_FREELIST_BLOCKS NUMBER

The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS NUMBER

The number of blocks on the freelist
AVG_CACHED_BLOCKS NUMBER

Average number of blocks in buffer cache
AVG_CACHE_HIT_RATIO NUMBER

Average cache hit ratio for the object
SAMPLE_SIZE NUMBER

The sample size used in analyzing this table
LAST_ANALYZED DATE

The date of the most recent time this table was analyzed
GLOBAL_STATS VARCHAR2 (3)
Are the statistics calculated without merging underlying partitions?
USER_STATS VARCHAR2 (3)
Were the statistics entered directly by the user?
STATTYPE_LOCKED VARCHAR2 (5)
type of statistics lock
STALE_STATS VARCHAR2 (3)
Whether statistics for the object is stale or not
SCOPE VARCHAR2 (7)
whether statistics for the object is shared or session
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      TABLE_NAME
,      PARTITION_NAME
,      PARTITION_POSITION
,      SUBPARTITION_NAME
,      SUBPARTITION_POSITION
,      OBJECT_TYPE
,      NUM_ROWS
,      BLOCKS
,      EMPTY_BLOCKS
,      AVG_SPACE
,      CHAIN_CNT
,      AVG_ROW_LEN
,      AVG_SPACE_FREELIST_BLOCKS
,      NUM_FREELIST_BLOCKS
,      AVG_CACHED_BLOCKS
,      AVG_CACHE_HIT_RATIO
,      SAMPLE_SIZE
,      LAST_ANALYZED
,      GLOBAL_STATS
,      USER_STATS
,      STATTYPE_LOCKED
,      STALE_STATS
,      SCOPE
,      CON_ID
FROM SYS.CDB_TAB_STATISTICS;

Dependencies

[top of page]

SYS.CDB_TAB_STATISTICS does not reference any database object

SYS.CDB_TAB_STATISTICS is referenced by following:

SchemaPUBLIC
SynonymCDB_TAB_STATISTICS