(B)0[m[4mANALYZE[m qwqq> [4mPAGES[m qqqqqqqqqqqqqqqqqqqqqqqqqqwq>
tqq> [4mRELATIONS[m qwqqqqqqqqqqqqqqqqqqqwqu
x mq> relation-name qqj x
twq> [4mINDEXES[m qqwwqqqqqqqqqqqqqqqqqqqwqu
xmq> [4mINDICES[m qqjmq> index-name qqqqqj x
mqq> [4mSEGMENTS[m qqqqqqqqqqqqqqqqqqqqqqqqj
1 – PAGES
Oracle Rdb displays a bar chart showing page usage for the database.
This chart indicates how many pages the database uses and the
percentage to which each page is filled.
2 – RELATIONS
Oracle Rdb displays a chart with the following information for each
relation defined for the database:
o Total number of records
o Total number of bytes
o Average number of bytes occupied by each record
o Percentage of records that are fragmented (split over more
than one database page)
o Percentage of total space available for a relation used to
store users' data
o Percentage of total space in a relation used to store users'
data
3 – SEGMENTS
Oracle Rdb displays a chart with the following information about the
segmented strings stored in the database:
o Total number of segmented string records
o Total number of bytes occupied by segmented strings
o Average number of bytes occupied by each segmented string
record
o Percentage of segmented string records that are fragmented
(split over more than one database page)
o Percentage of total space available for a relation that is
used to store users' data
o Percentage of total space in a relation used to store users'
data
4 – INDEXES
If you use the INDEXES or INDICES option, Oracle Rdb displays a
chart with five columns that consists of:
o The number of levels in the B-tree needed to store all the
index nodes.
o The total number of B-tree nodes in the index.
o The length (number of bytes) used for the index.
o The number of duplicate values in the index. This value is
always zero in an index defined with the DUPLICATES ARE NOT
ALLOWED clause.
o Any duplicate length used.