Updating Database Statistics with BR*Tools 

Use

You can use BR*Tools for Oracle to update 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 → Update database 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
SAP owner for update (owner)	-f stats -o|-owner
Exclude from update (exclude)	-f stats -e|-exclude
Tables for update (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 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.