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 which, from SAP’s experience, are frequently used by customers.

Analysis	For detailed information, see...
File activity statistics	File System Requests (Oracle)
Overview of wait situations	Wait Events (Oracle)
Wait situations in the data buffer (buffer busy waits)	Buffer Busy Waits (Oracle)
Data dictionary cache statistics	Dictionary Buffer (Oracle)
Performance statistics per application server	SAP Client (Oracle)
Resource consumption per Oracle shadow process	Oracle Sessions
Resource consumption by SQL statements	Monitoring the Shared SQL Area (Oracle)
Exclusive lockwaits	Exclusive Lockwaits (Oracle)
ALERT file	Database Message Log (Oracle)
Oracle statistics tables	Display V$ Tables (Oracle)
Overview of database performance	Performance Database (Oracle)
Monitoring datasets	State on Disk (Oracle)
Changes to init.ora parameters	Parameter Changes (Oracle)
Consistency checks	Consistency Checks
Missing indexes	Missing Indexes
Type of table scan	Table Scans: Problem Analysis (Oracle)
Checking tablespaces	Checking for Full Tablespaces (Oracle)
Monitoring storage space	Storage Management Errors (Oracle)
Free space analysis	Checking for Freespace Problems (Oracle)
Displaying storage parameters	Checking Storage Parameters (Oracle)
Extent analysis	Extent Analysis (Oracle)
MAXEXTENTS values	Problems with Maximum Number of Extents (Oracle)
Display of Oracle table statistics for the cost-based optimizer	Display of Oracle table statistics