![]()
|
This section describes about the working with the Statistics. The The topics covered are: |
![]() |
The optimizer uses statistics when determining access paths to the data. | ||
![]() |
This task explains how to use the statistics: | ||
![]() |
|
![]() |
The Collecting Statistics for the Entire Database allows you to collect statistics for all the objects in the database. You need to run this feature if your database has major updates. |
![]() |
This task explains how to collect statistics for the entire database: |
![]() |
|
![]() |
The Collecting Statistics for the Entire CISDBA Schema allows you to collect statistics for all the objects in the CISDBA schema. You need to run this feature if your database has major updates. |
![]() |
This task explains how to collect statistics for the entire schema: |
![]() |
|
![]() |
You can also gather statistics on just-the-stale objects, that is, objects that have been modified since the last time statistics were gathered. It can be used only for tables with the MONITORING attribute set. The statistics are considered STALE only when there are statistics already gathered on the table. You can enable or disable DML monitoring feature of all the tables in the CISDBA schema by clicking the Enable or Disable. The MONITORING attribute for specific tables in the CISDBA schema can be enabled or disabled in the Classes tab. |
![]() |
The Collecting Statistics for the Classes allows you to collect statistics for the classes (tables) in the CISDBA schema. From the Statistics page, select the Classes tab and select one or all the classes. The topics covered in this section are: |
|
You can collect statistics for classes in the CISDBA Schema. |
|
This task explains how to collect statistics for classes in the CISDBA Schema: |
![]() |
|
|
You can collect statistics for specific class or classes. |
|
This task explains how to collect statistics for specific class or classes: |
![]() |
|
![]() |
The Collecting Statistics for Indexes allows you to collect statistics for the indexes in the CISDBA schema. Select the Indexes tab and select one or all the indexes. The topics covered in this section are: |
|
You can collect statistics for Indexes in the CISDBA Schema. |
|
This task explains how to collect statistics for Indexes in the CISDBA Schema: |
![]() |
|
|
You can collect statistics for specific index or indexes. |
|
This task explains how to collect statistics for specific index or indexes: |
![]() |
|