eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.ALL_TAB_STATISTICS

Object Details

Object Name:	ALL_TAB_STATISTICS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Optimizer statistics for all tables accessible to the user

[View Source]

Columns

Name	Datatype	Length	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

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
FROM SYS.ALL_TAB_STATISTICS;

Dependencies

[top of page]

SYS.ALL_TAB_STATISTICS references the following:

SYS: DBMS_STATS - show dependent code; DBMS_STATS_INTERNAL - show dependent code; FIXED_OBJ$; MON_MODS_ALL$; OBJ$; OBJAUTH$; TAB$; TABCOMPARTV$; TABPARTV$; TABSUBPARTV$; TAB_STATS$; USER$

SYS.ALL_TAB_STATISTICS is referenced by following:

PUBLIC: ALL_TAB_STATISTICS