If the Alert Monitor indicates that the database has potential performance problems, you can analyze the database in more detail.
Use the analysis functions available from the main screen of the Database Monitor Database Performance Analysis (SAP/Oracle Database Monitor: Main Screen).
All these functions provide numeric information on the database. A lot of the information can also be displayed graphically. You can access the most important analysis functions by Detail analysis menu. You will find a list below of some of the diverse analysis options - these are options that, from our experience, are frequently used by customers.
Not all the analyses offered by the monitors are included in the list. Functions that you do not normally need are not listed. These functions are mainly used to analyze your SAP and database system.
Analysis Options
Analysis | For More Information |
---|---|
File activity statistics |
|
Overview of wait situations |
|
Wait situations in the data buffer (buffer busy waits) |
|
Data dictionary cache statistics |
|
Performance statistics per application server |
|
Resource consumption per Oracle shadow process |
|
Resource consumption by SQL statements |
|
Exclusive lockwaits |
|
ALERT file |
|
Oracle statistics tables |
|
Overview of database performance |
|
Monitoring datasets |
|
Changes to init.ora parameters |
|
Consistency checks |
|
Missing indexes |
|
Type of table scan |
|
Checking tablespaces |
|
Monitoring storage space |
|
Free space analysis |
|
Displaying storage parameters |
|
Extent analysis |
|
MAXEXTENTS values |
|
Display of Oracle table statistics for the cost-based optimizer |
Display of Oracle table statistics |