OWNER 

VARCHAR2(30) 

NOT NULL 

Owner of the table 

TABLE_NAME 

VARCHAR2(30) 

NOT NULL 

Name of the table 

TABLESPACE_NAME 

VARCHAR2(30) 

NOT NULL 

Name of the tablespace containing the table 

CLUSTER_NAME 

VARCHAR2(30) 

Name of the cluster, if any, to which the table belongs 

IOT_NAME 

VARCHAR2(30) 

Name of the index-organized table, if any, to which the overflow entry belongs 

PCT_FREE 

NUMBER 

Minimum percentage of free space in a block  

PCT_USED 

NUMBER 

Minimum percentage of used space in a block 

INI_TRANS 

NUMBER 

Initial number of transactions 

MAX_TRANS 

NUMBER 

Maximum number of transactions 

INITIAL_EXTENT 

NUMBER 

Size in bytes of the initial extent 

NEXT_EXTENT 

NUMBER 

Size in bytes of secondary extents 

MIN_EXTENTS 

NUMBER 

Minimum number of extents allowed in the segment 

MAX_EXTENTS 

NUMBER 

Maximum number of extents allowed in the segment 

PCT_INCREASE 

NUMBER 

Percentage increase in extent size 

FREELISTS 

NUMBER 

Number of process freelists allocated in this segment 

FREELIST_GROUPS 

NUMBER 

Number of freelist groups allocated in this segment  

LOGGING 

VARCHAR2(3) 

Logging attribute 

BACKED_UP 

VARCHAR2(1) 

Whether the table has been backed up since last modification 

NUM_ROWS  

NUMBER 

Number of rows in the table  

BLOCKS 

NUMBER 

Number of used blocks in the table 

EMPTY_BLOCKS 

NUMBER 

Number of empty (never used) blocks in the table 

AVG_SPACE  

NUMBER 

Average available free space in the table 

CHAIN_CNT 

NUMBER 

Number of chained rows in the table  

AVG_ROW_LEN 

NUMBER 

Average row length, including row overhead 

AVG_SPACE_FREELIST_BLOCKS 

NUMBER 

Average free space of all blocks on a freelist 

NUM_FREELIST_BLOCKS 

NUMBER 

Number of blocks on the freelist 

DEGREE 

VARCHAR2(10) 

Number of parallel execution processes per instance for scanning the table  

INSTANCES 

VARCHAR2(10) 

Number of instances across which the table is to be scanned 

CACHE 

VARCHAR2(5) 

Whether the cluster is to be cached in the buffer cache (CACHE | NOCACHE) 

TABLE_LOCK 

VARCHAR2(8) 

Whether table locking is enabled or disabled  

SAMPLE_SIZE 

NUMBER 

Sample size used in analyzing this table 

LAST_ANALYZED 

DATE 

Date on which this table was most recently analyzed  

PARTITIONED 

VARCHAR2(3) 

Whether the table is partitioned (YES | NO) 

IOT_TYPE 

VARCHAR2(12) 

If index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL 

OBJECT_ID_TYPE 

VARCHAR2(16) 

Whether the object ID (OID) is USER-DEFINED or SYSTEM-GENERATED 

TABLE_TYPE_OWNER 

VARCHAR2(30) 

NOT NULL 

Owner of the type of the table if the table is a typed table 

TABLE_TYPE 

VARCHAR2(30) 

NOT NULL  

Type of the table if the table is a typed table 

TEMPORARY 

VARCHAR2(1) 

Whether this is a temporary table 

SECONDARY 

VARCHAR2(1) 

Whether the object table is a secondary object created by the ODCIIndexCreate method of the Oracle8i Data Cartridge (Y | N) 

NESTED 

VARCHAR2(3) 

Whether the table a nested table 

BUFFER_POOL 

VARCHAR2(7) 

Default buffer pool to be used for table blocks 

ROW_MOVEMENT 

VARCHAR2(8) 

Whether partitioned row movement is ENABLED or DiSABLED 

GLOBAL_STATS 

VARCHAR2(3) 

For partitioned object tables, whether statistics were collected for the table as a whole (YES) or were estimated from statistics on underlying partitions and subpartitions (NO). 

USER_STATS 

VARCHAR2(3) 

Whether statistics were entered directly by the user 

DURATION 

VARCHAR2(15) 

Indicates the duration of a temporary table:

• SYS$SESSION: the rows are preserved for the duration of the session

• SYS$TRANSACTION: the rows are deleted after COMMIT.

Null for a permanent table. 

SKIP_CORRUPT 

VARCHAR2(8) 

Whether Oracle ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED). To enable this feature, run the DBMS_REPAIR.SKIP_CORRUPT_BLOCKS procedure.  

MONITORING 

VARCHAR2(3) 

Whether the table has the MONITORING attribute set