1  ANALYZE
   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
 

2  Format

 (B)0ANALYZE qwqq> PAGES  qqqqqqqqqqqqqqqqqqqqqqqqqqwq>
          tqq> RELATIONS qwqqqqqqqqqqqqqqqqqqqwqu
          x               mq> relation-name qqj x
          twq> INDEXES qqwwqqqqqqqqqqqqqqqqqqqwqu
          xmq> INDICES qqjmq> index-name qqqqqj x
          mqq> SEGMENTS qqqqqqqqqqqqqqqqqqqqqqqqj

 

3  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.
 

3  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
 

3  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.