Collecting Missing Statistics with BR*Tools

You can use BR*Tools for Oracle to collect missing database statistics. Missing statistics are automatically collected by update 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.