Detail Analysis Menu (Oracle)

You can use this procedure to display more detailed Oracle performance statistics.

1. Choose Tools → Administration → Computing Center → Management System → Control → Performance Menu →Database →Activity.

   Alternatively, use transaction codeST04.

2. Choose Detail analysis menu.

The analysis options displayed here are needed for advanced database monitoring operations. Some of the options are explained below:

Buffer Busy Waits (Oracle)

File System Requests (Oracle)

Wait Events (Oracle)

Dictionary Buffer (Oracle)

SAP Client (Oracle)

Oracle Sessions

Exclusive Lockwaits (Oracle)

Database Message Log (Oracle)

Display V$ Tables (Oracle)

Historical Database Performance Statistics (Oracle)

State on Disk (Oracle)

Parameter Changes (Oracle)