Collecting System Statistics with BR*Tools - SAP Documentation

Collecting System Statistics with BR*Tools

You can use BR*Tools for Oracle to collect system 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

Start BRGUI or BRTOOLS.
Choose Database statistics Collect system statistics .

Set the required options:

Menu Entry	Equivalent BRCONNECT Command Option
BRCONNECT profile (profile)	-p\|-profile
Database user/password (user)	-u\|-user
NOWORKLOAD mode (noworkload)	-f stats -i\|-inteval 0
Time interval in minutes (interval)	-f stats -i\|-interval
Confirmation mode (confirm)	-c\|-confirm
Message language (language)	-l\|-language
BRCONNECT command line (command)	This shows you the BRCONNECT -f stats -t SYSTEM_STATS -i <interval> 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 Profiles and Logs with BR*Tools.