1 – Full
Full
Nofull
This qualifier can only be used if table, index, or index prefix
cardinality statistics are being displayed. If this qualifier is
specified, the following cardinality information is displayed:
o Actual cardinality
Displays the current table, index, or index prefix cardinality
value.
o Stored cardinality
Displays the table, index, or index prefix cardinality value
stored in the system relations.
o Difference between the stored and actual cardinality values
This value is negative if the stored cardinality is less than
the actual cardinality.
o Percentage cardinality difference from the actual value
This value is calculated by dividing the difference between
the stored and actual cardinality values by the actual
cardinality value. It is negative if the stored cardinality
is less than the actual cardinality.
The default value is Nofull.
2 – Indexes
Indexes[=(index-list)]
Noindex
Specifies the index or indexes for which statistics are to be
displayed. If you do not specify an index-list, statistics for
all indexes defined for the tables specified with the Tables
qualifier are displayed. If you specify an index-list, statistics
are displayed only for the named indexes. If you specify the
Noindex qualifier, statistics are not displayed for any indexes.
The default is the Indexes qualifier without an index-list.
3 – Log
Log
Nolog
Log=file-name
Specifies whether the display of statistics are to be logged.
Specify the Log qualifier to have the information displayed
to SYS$OUTPUT. Specify the Log=file-spec qualifier to have the
information written to a file. The Nolog qualifier is valid
syntax, but is ignored by Oracle RMU. The default is the Log
qualifier.
4 – Statistics
Statistics
Statistics[=(options)]
Specifies the type of statistics you want to display for the
items specified with the Tables, System_Relations, and Indexes
qualifiers. If you specify the Statistics qualifier without
an options list, all statistics are displayed for the items
specified.
If you specify the Statistics qualifier with an options list,
Oracle RMU displays the types of statistics described in the
following list. If you specify more than one option, separate the
options with commas and enclose the options within parentheses.
The Statistics qualifier options are:
o Cardinality
Displays the table cardinality for the tables specified with
the Tables and System_Relations qualifiers and the index and
index prefix cardinalities for the indexes specified with the
Indexes qualifier.
o Workload
Displays the Column Group, Duplicity Factor, and Null Factor
workload statistics for the tables specified with the Tables
and System_Relations qualifiers.
o Storage
Displays the following statistics:
- Table Row Clustering Factor for the tables specified with
the Tables qualifier
- Index Key Clustering Factor, the Index Data Clustering
Factor, and the Average Index Depth for the indexes
specified with the Indexes qualifier.
5 – System Relations
System_Relations
Nosystem_Relations
The System_Relations qualifier specifies that optimizer
statistics are to be displayed for system tables (relations)
and their associated indexes.
If you do not specify the System_Relations qualifier, or if you
specify the Nosystem_Relations qualifier, optimizer statistics
are not displayed for system tables or their associated indexes.
Specify the Noindex qualifier if you do not want statistics
displayed for indexes defined on the system tables.
The default is the Nosystem_Relations qualifier.
6 – Tables
Tables
Tables=(table-list)
Notables
Specifies the table or tables for which optimizer statistics
are to be displayed. If you specify a table-list, optimizer
statistics for those tables and their associated indexes are
displayed.
If you do not specify the Tables qualifier, or if you specify
the Tables qualifier but do not provide a table-list, optimizer
statistics for all tables and their associated indexes in the
database are displayed.
If you specify the Notables qualifier, optimizer statistics for
tables are not displayed.
Specify the Noindex qualifier if you do not want statistics
displayed for indexes defined on the specified tables.
The Tables qualifier is the default.
7 – Threshold
Threshold=options
Nothreshold
The Threshold qualifier can only be used in conjunction with
the Full qualifier. If this qualifier is used, an additional
Threshold column is added to the display. You can specify the
following options with the Threshold qualifier:
o Percent=n
The value for Percent=n can be an integer value from 0 to 99.
The default value for n is 0. If Percent=n is not specified
or if a percent value of 0 is specified, any percentage
difference from the actual cardinality value is flagged as
"*over*" in the output column. If a percent value of 1 to
99 is specified, any percentage difference from the actual
cardinality value that is greater than the percent value
specified is flagged as "*over*" in the output column. In the
report, the Threshold column displays those cardinality values
in which the percent difference exceeds the specified value.
If the threshold is not exceeded, the column is blank. If the
threshold is exceeded, the column shows the string "*over*".
o Log={All|Over_Threshold}
If Log is not specified or if Log=All is specified, all
cardinality values are displayed. If Log=Over_Threshold is
specified, only cardinality values that exceed the threshold
percentage are flagged as "*over*" in the output column.