Diagnosing SAP/Oracle Performance Problems 

A Transaction is Running Very Slowly (Oracle)

Monitoring the Shared SQL Area (Oracle)

Monitoring Table and Index Fragmentation (Oracle)

All Transactions are Running Slowly (Oracle)

SQL Request (Shared SQL Area)

Checkpoint Monitoring (Oracle)

Checking the Optimizer Mode (Oracle)

Monitoring Oracle Resources

No Applications Can Run (‘Frozen’ System)