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.
You can use BR*Tools for Oracle to delete harmful database statistics.
Harmful statistics are statistics on tables where the ACTIVE flag is set to N in DBSTATC. This is an absolute exception since, in Oracle 10g or higher, all tables normally have statistics. Harmful statistics are automatically deleted by update database statistics.
Start BRGUI or BRTOOLS.
Choose
.Set the required options:
Menu Entry |
Equivalent BRCONNECT Command Option |
---|---|
BRCONNECT profile (profile) |
|
Database user/password (user) |
|
Database owner for delete (owner) |
|
Ignore DBSTATC settings (ignore) |
|
Exclude from delete (exclude) |
|
Tables for delete (table) |
|
Confirmation mode (confirm) |
|
Query mode (query) |
|
Force options (force) |
|
Extended output (output) |
|
Message language (language) |
|
BRCONNECT command line (command) |
This shows you the BRCONNECT -f stats -t harmful -d 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>.dst displays the progress.
For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.