Ah but then everything is fine ... Could we suggest buying a bigger machine :-) ?
>----- ------- Original Message ------- ----- >From: Jared Still <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> >> "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: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
