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.
...
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) |
|
Database user/password (user) |
|
Collection method (method) |
|
Sample size (sample) |
|
Bucket count (bucket) |
|
Change threshold (change) |
|
Database owner for collect (owner) |
|
Exclude from collect (exclude) |
|
Tables for collect (table) |
|
Confirmation mode (confirm) |
|
Query mode (query) |
|
Parallel threads (parallel) |
|
Update history tables (history) |
|
Retain old statistics (retain) |
|
Time limit in minutes (limit) |
|
Force options (force) |
|
Extended output (output) |
|
Message language (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.