Show TOC

Collecting Dictionary Statistics with BR*ToolsLocate this document in the navigation structure

Prerequisites

Context

You can use BR*Tools for Oracle to collect dictionary statistics.

Procedure


  1. Start BRGUI or BRTOOLS.

  2. Choose Start of the navigation path Database statistics Next navigation step Collect dictionary 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

    Collection method (method)

    -f stats -m|-method

    Sample size (sample)

    -f stats -s|-sample

    DBMS_STATS parallel degree (degree)

    -f stats d|-degree

    Force options (force)

    -f stats -f|-force

    Confirmation mode (confirm)

    -c|-confirm

    Message language (language)

    -l|-language

    BRCONNECT command line (command)

    This shows you the BRCONNECT -f stats -t oradict_stats 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>.sta displays the progress.

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