Databases Reference
In-Depth Information
Fields
The most relevant view fields are as follows:
F
NAME
: The name of the index
F
HEIGHT
: The height of the B-tree index
F
BLOCKS
: The number of allocated database blocks
F
BTREE_SPACE
: The total space allocated
F
USED_SPACE
: The total space used
F
DISTINCT_KEYS
: The number of distinct keys in the index
F
OPT_CMPR_COUNT
: The optimal key compression length
F
OPT_CMPR_PCTSAVE
: Space saving corresponding to the adoption
of the optimal key compression length
See also
F
The
DBA_INDEXES
section in this appendix
DBA_SEQUENCES
This lists all the user sequences. It's a synonym for
USER_SEQUENCES
.
Fields
The most relevant view fields are as follows:
F
SEQUENCE_OWNER
: The owner of the sequence
F
SEQUENCE_NAME
: The name of the sequence
F
MIN_VALUE
: The minimum value of the sequence
F
MAX_VALUE
: The maximum value of the sequence
F
INCREMENT_BY
: The value by which the sequence is incremented
F
CYCLE_FLAG
: This indicates whether the sequence numbering restarts after
it has reached the upper limit
F
ORDER_FLAG
: This indicates whether the sequence is ordered (numbers
generated in order) or not; this is useful in an RAC environment
F
CACHE_SIZE
: The number of sequence numbers to cache
F
LAST_NUMBER
: The last number written to disk; if caching is enabled, it is
the last number placed in the sequence cache