The RDO ANALYZE statement is available for single-file databases
only. Use the RMU/ANALYZE command for multifile databases.
Displays statistics on how the database is using space.
ANALYZE works on the database most recently invoked, and uses
a read/write transaction.
You can display statistics on pages, relations, indexes, or
segments.
Example:
RDO> ANALYZE RELATION EMPLOYEES
1 – Format
(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.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.
1.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
1.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
1.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.
2 – More
You must have the Oracle Rdb ADMINISTRATOR privilege to use the
ANALYZE statement.