Database Reference
In-Depth Information
Troubleshooting performance issues
Troubleshooting performance issues is a rather vast and complicated area, which
we will only be able to touch upon lightly. In general, performance becomes a
concern when a transaction is unable to execute within a reasonable or expec-
ted time, or when the system is unavailable to process expected volumes. Some-
times this may be specific to a single transaction, other times it is something that
is affecting every composite instance running on the server. The ultimate aim is
to speed up the execution time of transactions by minimizing any undue delays
and waits at the infrastructure level.
Server wide performance issues
When server wide performance problems occur, this should impact most or all of
the transactions currently executing on your infrastructure. For example, if the de-
hydration store database is down or performing poorly, this will undoubtedly have
an impact on all running instances.
Consider asking yourself a few questions to determine if there is an overarching
infrastructure problem:
•
Is logging in to Oracle Enterprise Manager Fusion Middleware Control ex-
tremely slow?
•
Are all composite instances completing in an unusually longer period of time?
•
Are the logs or your dehydration database growing unusually quickly?
•
Are you seeing an exceptionally high number of errors in the logs?
These are usually indications that there may be a server wide performance prob-
lem. Performance issues impacting the entire server are usually related to either
one or a few specific issues. In this case, take a look at the following.
