|
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 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 |
|
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 or IOT_OVERFLOW. 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 Oracle8i Data Cartridge (Y or 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 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 |
