Detail Analysis Menu (Oracle) 

Use

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

Procedure

...

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

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)

Historical Database Performance Statistics (Oracle)

State on Disk (Oracle)

Parameter Changes (Oracle)