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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: quick suggestions for tuning ?

RE: Re: quick suggestions for tuning ?

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 11 Aug 2003 08:39:24 -0800
Message-ID: <F001.005CA1A4.20030811083924@fatcity.com>


Ah but then everything is fine ... Could we suggest buying a bigger machine :-) ?

>----- ------- Original Message ------- -----
>From: Jared Still <jkstill_at_cybcon.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Mon, 11 Aug 2003 07:44:23
>
>
>But his BCHR is 99.57% !
>
>On Sun, 2003-08-10 at 07:44, Connor McDonald wrote:
>
>> 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).
>
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>--
>Author: Jared Still
> INET: jkstill_at_cybcon.com
>
>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).
>___________________________________________________
>_____________________
>---------------------------------------------------
>------------------
>---------------------------------------------------
>------------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

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 Mon Aug 11 2003 - 11:39:24 CDT

Original text of this message

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