|
OWNER
|
VARCHAR2(30)
|
NOT NULL
|
Owner of the table
|
|
TABLE_NAME
|
VARCHAR2(30)
|
NOT NULL
|
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 (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
|
|
TABLE_TYPE
|
VARCHAR2(30)
|
NOT NULL
|
Type of the 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 sessionSYS$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
|
