Show TOC

<Icon> Name of RoleLocate this document in the navigation structure

All Transactions are Running Slowly (Oracle)

You may encounter situations where all applications appear to be performing poorly.

The questions to ask should include:

  • Has anything changed?
  • When did this performance degradation start?
  • Are all applications really running slowly or is the user telling you this out of frustration over their application performing poorly?
  • Is this problem intermittent or constant?

If the answers to these questions lead you to believe there is a system-wide performance problem, the following topics may help you determine the cause.

Monitoring the Shared SQL Area (Oracle)

Checkpoint Monitoring (Oracle)

Checking the Optimizer Mode (Oracle)

Monitoring Oracle Resources

Missing Indexes

Keep in mind that a single poorly-performing application may use considerable system resources causing other non-related applications to falter. For this reason, it is a good idea to also review the subjects discussed in other sections when tracing down a system-wide problem.