|
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; NULL for partitioned, temporary and index-organized tables
|
|
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. If IOT_TYPE column is not null, this column contains the base table name.
|
|
PCT_FREE
|
NUMBER
|
|
Minimum percentage of free space in a block; NULL for partitioned tables
|
|
PCT_USED
|
NUMBER
|
|
Minimum percentage of used space in a block; NULL for partitioned tables
|
|
INI_TRANS
|
NUMBER
|
|
Initial number of transactions; NULL for partitioned tables
|
|
MAX_TRANS
|
NUMBER
|
|
Maximum number of transactions; NULL for partitioned tables
|
|
INITIAL_EXTENT
|
NUMBER
|
|
Size of the initial extent in bytes; NULL for partitioned tables
|
|
NEXT_EXTENT
|
NUMBER
|
|
Size of the secondary extension bytes; NULL for partitioned tables
|
|
MIN_EXTENTS
|
NUMBER
|
|
Minimum number of extents allowed in the segment; NULL for partitioned tables
|
|
MAX_EXTENTS
|
NUMBER
|
|
Maximum number of extents allowed in the segment; NULL for partitioned tables
|
|
PCT_INCREASE
|
NUMBER
|
|
Percentage increase in extent size; NULL for partitioned tables
|
|
FREELISTS
|
NUMBER
|
|
Number of process freelists allocated to this segment; NULL for partitioned tables
|
|
FREELIST_GROUPS
|
NUMBER
|
|
Number of freelist groups allocated to this segment; NULL for partitioned tables
|
|
LOGGING
|
VARCHAR2(3)
|
|
Logging attribute; NULL for partitioned tables
|
|
BACKED_UP
|
VARCHAR2(1)
|
|
Has table been backed up since last change
|
|
NUM_ROWS*
|
NUMBER
|
|
Number of rows in the table
|
|
BLOCKS*
|
NUMBER
|
|
Number of used data blocks in the table
|
|
EMPTY_BLOCKS*
|
NUMBER
|
|
Number of empty (never used) data blocks in the table
|
|
AVG_SPACE*
|
NUMBER
|
|
Average amount of free space, in bytes, in a data block allocated to the table
|
|
CHAIN_CNT*
|
NUMBER
|
|
Number of rows in the table that are chained from one data block to another, or which have migrated to a new block, requiring a link to preserve the old ROWID
|
|
AVG_ROW_LEN*
|
NUMBER
|
|
Average length of a row in the table in bytes
|
|
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
|
|
DEGREE
|
VARCHAR2(10)
|
|
The number of threads per instance for scanning the table
|
|
INSTANCES
|
VARCHAR2(10)
|
|
The 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)
|
|
Indicates whether this table is partitioned. Set to YES if it is partitioned.
|
|
IOT_TYPE
|
VARCHAR2(12)
|
|
If this is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. If this is not an index-organized table, then IOT_TYPE is NULL.
|
|
TEMPORARY
|
VARCHAR2(1)
|
|
Can the current session only see data that it place in this object itself?
|
|
SECONDARY
|
VARCHAR2(1)
|
|
Whether the trigger is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y |N)
|
|
NESTED
|
VARCHAR2(3)
|
|
Is the table a nested table?
|
|
BUFFER_POOL
|
VARCHAR2(7)
|
|
The default buffer pool for the object. NULL for partitioned tables
|
|
ROW_MOVEMENT
|
VARCHAR2(8)
|
|
Whether partitioned row movement is enabled or disabled
|
|
GLOBAL_STATS
|
VARCHAR2(3)
|
|
For partitioned tables, indicates 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)
|
|
Were the statistics 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
|
