Re: "Practicing" Oracle performance tuning ...
Date: Thu, 09 Apr 2009 09:54:03 -0500
That's a cool video - can't you do the same thing with Database Control (or Grid Control)?
kyle Hailey wrote:
> 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
> 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
> 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
-- Jeremy Schneider Chicago, IL http://www.ardentperf.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 09 2009 - 09:54:03 CDT