Collecting Missing Statistics with BR*Tools

Use

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

Prerequisites

·        Make sure you have set the necessary BRCONNECT parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRCONNECT.

·        The database must be open.

Procedure

...

       1.      Start BRGUI or BRTOOLS.

       2.      Choose Database statistics ® Collect missing statistics.

       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 (bucket)

-f stats –b|-bucket

Change threshold (change)

-f stats -c|change

Database owner for collect (owner)

-f stats -o|-owner

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>.logdisplays 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.