Analyzing Entire CISDBA Schema

About Analyzing Entire CISDBA Schema

This option allows you to analyze the entire CISDBA Schema.

This task explains the procedure to analyze the entire CISDBA Schema:

  1. Log on as cisdba and run edm.sh from $EDS_HOME/bin directory. For additional information, see Using CES Database Manager.

  2. From the EDM main window, select the database to be analyzed.

  3. Select Tools > Update Statistics option.

    The Update Statistics window appears

In this window, you can choose to analyze the entire CISDBA schema. Select the Entire CISDBA schema check box and click Analyze. The statistics will be updated for all the tables and indexes in the CISDBA schema.