|
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
STATUS
VARCHAR2(8)
NUM_ROWS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
DEGREE
VARCHAR2(40)
INSTANCES
VARCHAR2(40)
PARTITIONED
VARCHAR2(3)
TEMPORARY
VARCHAR2(1)
GENERATED
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
BUFFER_POOL
VARCHAR2(7)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
PCT_DIRECT_ACCESS
NUMBER
ITYP_OWNER
VARCHAR2(30)
ITYP_NAME
VARCHAR2(30)
PARAMETERS
VARCHAR2(1000)
GLOBAL_STATS
VARCHAR2(3)
DOMIDX_STATUS
VARCHAR2(12)
DOMIDX_OPSTATUS
VARCHAR2(6)
FUNCIDX_STATUS
VARCHAR2(8)
JOIN_INDEX
VARCHAR2(3)
IOT_REDUNDANT_PKEY_ELIM
VARCHAR2(3)
DROPPED
VARCHAR2(3)
DBA_INDEXTYPES: All index types
iSelfSchooling-SQL> desc DBA_INDEXTYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
IMPLEMENTATION_SCHEMA
NOT NULL VARCHAR2(30)
IMPLEMENTATION_NAME
NOT NULL VARCHAR2(30)
INTERFACE_VERSION
NUMBER
IMPLEMENTATION_VERSION
NOT NULL NUMBER
NUMBER_OF_OPERATORS
NUMBER
PARTITIONING
VARCHAR2(10)
ARRAY_DML
VARCHAR2(3)
DBA_INDEXTYPE_ARRAYTYPES: All array types specified by the indextype
iSelfSchooling-SQL> desc DBA_INDEXTYPE_ARRAYTYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
BASE_TYPE_SCHEMA
VARCHAR2(30)
BASE_TYPE_NAME
VARCHAR2(30)
BASE_TYPE
VARCHAR2(30)
ARRAY_TYPE_SCHEMA
NOT NULL VARCHAR2(30)
ARRAY_TYPE_NAME
NOT NULL VARCHAR2(30)
DBA_INDEXTYPE_COMMENTS: Comments for user-defined indextypes
iSelfSchooling-SQL> desc DBA_INDEXTYPE_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
DBA_INDEXTYPE_OPERATORS: All indextype operators
iSelfSchooling-SQL> desc DBA_INDEXTYPE_OPERATORS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
OPERATOR_SCHEMA
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
DBA_IND_COLUMNS: COLUMNs comprising INDEXes on all TABLEs and
CLUSTERs
iSelfSchooling-SQL> desc DBA_IND_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NOT NULL NUMBER
COLUMN_LENGTH
NOT NULL NUMBER
CHAR_LENGTH
NUMBER
DESCEND
VARCHAR2(4)
DBA_IND_EXPRESSIONS: FUNCTIONAL INDEX EXPRESSIONs on all TABLES and
CLUSTERS
iSelfSchooling-SQL> desc DBA_IND_EXPRESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_EXPRESSION LONG
COLUMN_POSITION
NOT NULL NUMBER
DBA_IND_PARTITIONS
iSelfSchooling-SQL> desc DBA_IND_PARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
VARCHAR2(30)
INDEX_NAME
VARCHAR2(30)
COMPOSITE
VARCHAR2(3)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_COUNT
NUMBER
HIGH_VALUE
LONG
HIGH_VALUE_LENGTH
NUMBER
PARTITION_POSITION
NUMBER
STATUS
VARCHAR2(8)
TABLESPACE_NAME
VARCHAR2(30)
PCT_FREE
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENT
NUMBER
MAX_EXTENT
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(7)
COMPRESSION
VARCHAR2(8)
BLEVEL
NUMBER
LEAF_BLOCKS
NUMBER
DISTINCT_KEYS
NUMBER
AVG_LEAF_BLOCKS_PER_KEY
NUMBER
AVG_DATA_BLOCKS_PER_KEY
NUMBER
CLUSTERING_FACTOR
NUMBER
NUM_ROWS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
BUFFER_POOL
VARCHAR2(7)
USER_STATS
VARCHAR2(3)
PCT_DIRECT_ACCESS
NUMBER
GLOBAL_STATS
VARCHAR2(3)
DOMIDX_OPSTATUS
VARCHAR2(6)
PARAMETERS
VARCHAR2(1000)
DBA_IND_STATISTICS: Optimizer statistics for all indexes in the
database
iSelfSchooling-SQL> desc DBA_IND_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
INDEX_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
PARTITION_POSITION
NUMBER
SUBPARTITION_NAME
VARCHAR2(30)
SUBPARTITION_POSITION
NUMBER
OBJECT_TYPE
VARCHAR2(12)
BLEVEL
NUMBER
LEAF_BLOCKS
NUMBER
DISTINCT_KEYS
NUMBER
AVG_LEAF_BLOCKS_PER_KEY
NUMBER
AVG_DATA_BLOCKS_PER_KEY
NUMBER
CLUSTERING_FACTOR
NUMBER
NUM_ROWS
NUMBER
AVG_CACHED_BLOCKS
NUMBER
AVG_CACHE_HIT_RATIO
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
STATTYPE_LOCKED
VARCHAR2(5)
STALE_STATS
VARCHAR2(3)
DBA_IND_SUBPARTITIONS
iSelfSchooling-SQL> desc DBA_IND_SUBPARTITIONS;
|