Re: Evaluating overall performance
Date: Fri, 9 Apr 2010 06:11:52 -0700 (PDT)
Message-ID: <d87fb58b-a421-4ee0-a566-576876a1daf4_at_30g2000yqi.googlegroups.com>
On Apr 8, 10:58 am, AD <alain.den..._at_gmail.com> wrote:
snip
> I yet need to find material on "seeing the big picture" so to be able
> to describe and evaluate the performance of an Oracle system.
>
> The books I own are very good on drilling down to the fine details of
> a query, but I need to do the opposite and improve my skill on
> "measuring" the performance of the whole server, enabling me to
> communicate with others why the system is in good shape or why it
> needs attention.
>
> ..sort of the opposite of "tuning" for a specific tasks, and more like
> assessing the actual performance of the server...
>
> any good books, articles and links are welcomed,
>
> Thanks,
>
> Alain
Typically you can do some kind of repeatable benchmark against a server. Often these are done using home grown PLSQL against your own schemas to have the most relevance. Various vendors ( such as Quest with Benchmark Factory ) have some tools that might be useful.
Another option ( if you are licensed ) is doing daily AWR reports during a busy time frame ( I do 9 am to 5 pm monday thru friday ) which gives you a broad look at performance metrics throughout the whole day. This is a replacement for the old bstat/estat type of thing.
Is it particularly useful? Well kinda/sorta not so much for specific problems. As a broad overview of your database performance over so many hours yes it can be useful at times. The old technique of seeing what SQL is doing the most logical IO's and/or reads and trying to fix that SQL can be seen from those reports as well as the overall system performance metrics.
What you can get from the AWR reports also depends on your experience base. Christian Antognini has a useful book out on performance that you might want to look at. Have you purchased and read Cary Millsap's Optimizing Oracle Performance? Received on Fri Apr 09 2010 - 08:11:52 CDT