Re: Re: "Practicing" Oracle performance tuning ...

From: kyle Hailey <kylelf_at_gmail.com>
Date: Thu, 9 Apr 2009 07:39:47 -0700
Message-ID: <6f373fd20904090739p12ec373du80478241e34b0267_at_mail.gmail.com>

Like Cary said, profiling is the way to go. Profile the database see if there are issues at the

    machine (io,cpu)
    application - locks, invalid SQL
    database configuration - cache sizes, storage settings, log file sizing     SQL - slow ore high resource
The easiest way I know to see this is with DB Optimizer at Embarcadero. Check it out at

http://sites.google.com/site/embtdbo/

There is a free 14 day dowload on the above URL as well as some videos showing how to profile and tune a database. One video that isn't linked on the above URL is
http://www.youtube.com/watch?v=LtjYRSJ48fk which shows a case of log file IO issues, first identifying the problem then fixing it.
The methodology is based on Oracle wait events which are the keys to to profiling the database and identifying issues.

Best Wishes
Kyle Hailey
http://perfvision.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 09 2009 - 09:39:47 CDT