Message-ID: <F001.005C9E9C.20030810064425@fatcity.com>
Date: Sun, 10 Aug 2003 06:44:25 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: =?iso-8859-1?q?Connor=20McDonald?= <hamcdc@yahoo.co.uk>
Subject: Re: quick suggestions for tuning ?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Its not really rocket science here...

CPU is at the top of the timed event - and what causes
CPU (or is the most common cause) - logical I/O.  54
million consistent gets later down in the report
probably a bit of a giveaway there :-)

Next section in the report is some nice queries that
use up 4 or so million buffer gets.  Good ones to
start with...  As you've already noticed, no bind
variables.

Then some other miscellaneous things - look at how
much free memory you have in most of your pools "SGA
breakdown difference" - might be able to use that
better elsewhere.

cheers
connor


 --- Prem Khanna J <jprem@kssnet.co.jp> wrote: > Guys,
> 
> I have attached statspack report here.
> The ENV is Oracle 9.2.0.3 / Win2k AS - SP3.
> 
> 1.Can you tell me which INIT parameters are to be
> changed 
> which will give improved performance ?
> 
> 2.can someone give a rough idea about where the
> bottlenecks are ?
> 
> I read the doc "228913.1 - Systemwide Tuning using
> STATSPACK Reports" 
> and gave a try with YAPP also.
> 
> Bind vars are to be used - that is one i found out
> from statspack 
> report.
> 
> just new to statspack and so i'm seeking ur
> suggestions.
> 
> Regards,
> Jp.
> 

> ATTACHMENT part 2 application/octet-stream 
 

=====
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc@yahoo.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).