Detail Analysis Menu (Oracle) 

To display more detailed Oracle performance statistics:

  1. From the R/3 main screen, choose: Tools ® Administration ® Computing Center ® Management System ® Control ® Performance Menu ® Database ® Activity

    2. Alternatively, use transaction code ST04.

  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)

Performance Database (Oracle)

State on Disk (Oracle)

Parameter Changes (Oracle)