Re: Evaluating overall performance

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Thu, 8 Apr 2010 08:39:17 -0700 (PDT)
Message-ID: <44090e6b-aab4-4874-929a-7bdb74aace07_at_u22g2000yqf.googlegroups.com>



On Apr 8, 10:58 am, AD <alain.den..._at_gmail.com> wrote:
> Hi,
>
> I've been on the development side of things most of the time for the
> past years,
> but lately getting to do more dba work.
>
> 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

Alain,

What version of Oracle are you running (for example: 8.1.7.3, 9.2.0.1, 10.2.0.4, 11.1.0.7, 11.2.0.1)? Are you running the Standard Edition or the Enterprise Edition? Have you purchased any additional cost licenses, such as a Diagnostic Pack license?

Probably one of the best sites to investigate is Jonathan Lewis' blog. He has an excellent series on the topic of Statspack reports, which provide a system-wide *averages* overview of your database performance:
http://jonathanlewis.wordpress.com/statspack-examples/

Assuming that you are running Oracle 10.1 or greater, you can also take a look at the combination of time model data and wait event deltas. I have a three part series here (includes a script to automate the delta collection):
http://hoopercharles.wordpress.com/2010/01/13/working-with-oracle-time-model-data/

The chapters that I co-wrote with Randolf Geist in the Expert Oracle Practices book might also prove to be helpful, as well as several of the other chapters in that book.

Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Thu Apr 08 2010 - 10:39:17 CDT

Original text of this message