 |
|
ss
Oracle Tips by Burleson |
Sample run of the addmrpt
report
The header of this report contains
information on the period of time when this report was run, as well
as information on the database and instance for which it was run.
The body of the report is presented as a series of findings. Each
finding is presented with an overall bottleneck report, and one or
more recommendations on how to ease that bottleneck. Each
recommendation displays an estimated benefit available by following
the said recommendation.
The first finding is that the CPU is the
biggest bottleneck. The first recommendation is to add more CPUs or
add instances to support this load. In this case, adding more
instances would not resolve the problem since the average load, as
shown by the header information, is only 1.2 sessions. Adding CPUs
would only enhance performance if the busy session was able to take
advantage of the parallelism offered by an increased CPU count. If
this is a batch job, there is likely some serious redesign that will
be required to support this approach since simply putting more CPUs
in a machine will not necessarily improve performance for a given
user.
The above book excerpt is from:
Oracle Wait Event Tuning
High Performance with Wait
Event Iinterface Analysis
ISBN 0-9745993-7-9
Stephen Andert
http://www.rampant-books.com/book_2004_2_wait_tuning.htm |
