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 |