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

  • From: kyle Hailey <kylelf@xxxxxxxxx>
  • To: RameshGeecee@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Apr 2009 07:39:47 -0700

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: