Re: quick suggestions for tuning ?

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Sun, 10 Aug 2003 06:44:25 -0800
Message-ID: <F001.005C9E9C.20030810064425@fatcity.com>

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_at_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_at_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_at_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_at_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).

Received on Sun Aug 10 2003 - 09:44:25 CDT