Show TOC

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

Prerequisites

Context

You can use BR*Tools for Oracle to collect missing database statistics. Missing statistics are automatically collected by update database statistics.

Procedure


  1. Start BRGUI or BRTOOLS.

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

    Bucket count (buckets)

    -f stats -b|-buckets

    DBMS_STATS parallel degree (degree)

    -f stats -g|-degree

    Change threshold (change)

    -f stats -c|-change

    Database owner for collect (owner)

    -f stats -o|-owner

    Ignore DBSTATC settings (ignore)

    -f stats -n|-ignore

    Exclude from collect (exclude)

    -f stats -e|-exclude

    Tables for collect (table)

    -f stats -t|-table

    Confirmation mode (confirm)

    -c|-confirm

    Query mode (query)

    -q|-query

    Parallel threads (parallel)

    -f stats -p|-parallel

    Update history tables (history)

    -f stats -h|-history

    Retain old statistics (retain)

    -f stats -r|-retain

    Time limit in minutes (limit)

    -f stats -l|-limit

    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 missing 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 Logs with BR*Tools.