Show TOC

Procedure documentationUpdating Statistics for Groups of Tables in CCMS (Oracle) Locate this document in the navigation structure

 

You can use this procedure to update the statistics for groups of tables in your Oracle database.

Recommendation Recommendation

We normally recommend you to schedule update statistics in the DBA Planning Calendar, so that it is automatically executed at regular intervals.

End of the recommendation.

Prerequisites

This procedure uses BRCONNECT to update statistics.

Procedure

  1. Choose   Administration   CCMS   DB Administration   Cost-based optimizer   Create statistics  . Alternatively, call transaction DB20.

  2. Choose Standard operations.

  3. Select one of the following:

    • Update Statistics

      Deletes unwanted statistics, checks statistics for each table and updates them if required, using brconnect -f stats with the option -t all.

    • Update Statistics (DBSTATC)

      Updates statistics for tables with an entry in the DBSTATC control table, using brconnect -f stats with the option -t dbstatc_tab.

    • Create missing

      Creates statistics for all tables and indexes that ought to have statistics but do not currently, using brconnect -f stats with the option -t missing.

    • HARMFUL

      Deletes damaging statistics using brconnect -f stats with the option –d harmful.

  4. Choose Start to activate the selected function.

  5. To check the results, choose DBA Operations.

    For more information, see Displaying DBA Logs (Oracle).