Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$SQLAREA to determine most disk intensive SQL

Re: V$SQLAREA to determine most disk intensive SQL

From: Mark <simmons_mark_at_yahoo.com>
Date: 5 Mar 2004 16:17:44 -0800
Message-ID: <5366fb41.0403051617.17d4870e@posting.google.com>


Srivenu is correct that you shouldn't just look at your disk reads for tuning. Pick up a copy of Cary Milsap & Jeff Holt's book entitled "Oracle Performance Tuning". Cary wrote the paper that Srivenu has referenced.

If you haven't done so already, setup statspack to run at regular intervals. There's a script in the $ORACLE_HOME/rdbms/admin directory to do this for you if you don't know how.

A Statspack report is probably the fastest/easiest way to pick the low hanging fruit on any system that needs performance tuning. Another good thing about this report is that you can send it to any DBA that knows performance tuning, and they can tell you where to start even if you don't know how to read it yourself.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0403032328.4fa372d3_at_posting.google.com>...
> Please refer to this good article from Cary Millsap
> http://www.hotsos.com/dnloads/1.Millsap2001.02.26-CacheRatio.pdf
> regards
> Srivenu
Received on Fri Mar 05 2004 - 18:17:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US