ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_INDEXES: Description for all indexes in the database
iSelfSchooling-SQL> desc DBA_INDEXES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
INDEX_TYPE
VARCHAR2(27)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
UNIQUENESS
VARCHAR2(9)
COMPRESSION
VARCHAR2(8)
PREFIX_LENGTH
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
PCT_THRESHOLD
NUMBER
INCLUDE_COLUMN
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
PCT_FREE
NUMBER
LOGGING
VARCHAR2(3)
BLEVEL
NUMBER
LEAF_BLOCKS
NUMBER
DISTINCT_KEYS
NUMBER
AVG_LEAF_BLOCKS_PER_KEY
NUMBER
AVG_DATA_BLOCKS_PER_KEY
NUMBER
CLUSTERING_FACTOR
NUMBER
|