OWNER |
VARCHAR2(30) |
|
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
|
Name of the table |
TABLESPACE_NAME |
VARCHAR2(30) |
|
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 of the initial extent in bytes |
NEXT_EXTENT |
NUMBER |
|
Size of secondary extents in bytes |
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 the 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 rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid. This column is updated only after you ANALYZE the table. |
AVG_ROW_LEN |
NUMBER |
|
Average row length, including row overhead |
AVG_SPACE_FREELIST_BLOCKS |
NUMBER |
|
Average freespace of all blocks on a freelist |
NUM_FREELIST_BLOCKS |
NUMBER |
|
Number of blocks on the freelist |
DEGREE |
VARCHAR2(10) |
|
Number of threads 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 this table is partitioned: YES or NO |
IOT_TYPE |
VARCHAR2(12) |
|
If an index organized table, whether an overflow segment has been specified (OVERFLOW) or not (NULL) |
OBJECT_ID_TYPE |
VARCHAR2(16) |
|
Whether the object ID is USER-DEFINED or SYSTEM GENERATED |
TABLE_TYPE_OWNER |
VARCHAR2(30) |
|
If an object table, owner of the type from which the table is created |
TABLE_TYPE |
VARCHAR2(30) |
|
If an object table, type of the table |
TEMPORARY |
VARCHAR2(1) |
|
Whether the table is temporary |
SECONDARY |
VARCHAR2(1) |
|
Whether the table is a secondary object created by the ODCIIndexCreate method of the Oracle8i Data Cartridge to contain the contents of a domain index (Y or N) |
NESTED |
VARCHAR2(3) |
|
Whether this is a nested table |
BUFFER_POOL |
VARCHAR2(7) |
|
Default buffer pool for the table |
ROW_MOVEMENT |
VARCHAR2(8) |
|
If a partitioned table, whether row movement is enabled or disabled |
GLOBAL_STATS |
VARCHAR2(3) |
|
For partitioned tables, indicates whether statistics were collected by analyzing 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 |