Show TOC

 Detailed Analysis (Oracle)Locate this document in the navigation structure

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.

Note

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

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

Historical Database Performance Statistics (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