Use the DBMS_STATS package to generate statistics.

Statistics generated include the following:

[@more@]

Use the DBMS_STATS package to generate statistics.

Statistics generated include the following:

Table statistics
- Number of rows
- Number of blocks
- Average row length
Column statistics
- Number of distinct values (NDV) in column
- Number of nulls in column
- Data distribution (histogram)
Index statistics
- Number of leaf blocks
- Levels
- Clustering factor
System statistics
- I/O performance and utilization
- CPU performance and utilization

ITPub博客

statistics！