Collecting Missing Statistics with BR*Tools

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

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.

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.

To start processing with the selected options, choose Continue.
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.