[Home] [Help] [Dependency Information]
Object Name: | DBA_TAB_STATISTICS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Optimizer statistics for all tables in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Owner of the object | |
TABLE_NAME | VARCHAR2 | (128) | Name of the table | |
PARTITION_NAME | VARCHAR2 | (128) | Name of the partition | |
PARTITION_POSITION | NUMBER | Position of the partition within table | ||
SUBPARTITION_NAME | VARCHAR2 | (128) | 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 |
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
FROM SYS.DBA_TAB_STATISTICS;
|
|
|