Re: "Practicing" Oracle performance tuning ...

From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Thu, 09 Apr 2009 09:54:03 -0500
Message-ID: <49DE0C0B.6070806_at_ardentperf.com>

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
>
> 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
>
>
>
>

-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com

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

Received on Thu Apr 09 2009 - 09:54:03 CDT