Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: quick suggestions for tuning ?
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
![]() |
![]() |