Show TOC

Deleting Harmful Statistics with BR*ToolsLocate this document in the navigation structure

Prerequisites

Context

You can use BR*Tools for Oracle to delete harmful database statistics.

Harmful statistics are statistics on tables where the ACTIVE flag is set to N in DBSTATC. This is an absolute exception since, in Oracle 10g or higher, all tables normally have statistics. Harmful statistics are automatically deleted by update database statistics.

Procedure


  1. Start BRGUI or BRTOOLS.

  2. Choose Start of the navigation path Database statistics Next navigation step Delete harmful statistics End of the navigation path.

  3. Set the required options:

    Menu Entry

    Equivalent BRCONNECT Command Option

    BRCONNECT profile (profile)

    -p|-profile

    Database user/password (user)

    -u|-user

    Database owner for delete (owner)

    -f stats -o|-owner

    Ignore DBSTATC settings (ignore)

    -f stats -n|-ignore

    Exclude from delete (exclude)

    -f stats -e|-exclude

    Tables for delete (table)

    -f stats -t|-table

    Confirmation mode (confirm)

    -c|-confirm

    Query mode (query)

    -q|-query

    Force options (force)

    -f stats -f|-force

    Extended output (output)

    -o|-output

    Message language (language)

    -l|-language

    BRCONNECT command line (command)

    This shows you the BRCONNECT -f stats -t harmful -d command that is to be executed using the current settings.

  4. To start processing with the selected options, choose Continue.

  5. Check the results in the BRCONNECT logs.

    • The summary log conn<DBSID>.log displays the return code.

    • The detail log c<encoded timestamp>.dst displays the progress.

    For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.