Set up a dbms_job to run the command "select 'x' from dual;" every 10 seconds or so. I think you'll find that your hit ratio increases quite nicely.
Oh, the only potential downside is that your overall system performance might go down, way down! But your ratios are great! It is kind of like taking your car into the mechanic and complaining it only goes 20 miles per hour. He runs some tests and says, "Everything is fine, there are not any performance problems because your gas mileage is 30 miles per gallon." The two are not related. Seriously, don't focus on the ratio. Check out the great papers on www.hotsos.com, www.orapub.com and www.evdbt.com. And buy a copy of Oracle Performance Tuning 101 from Oracle Press. Focus on wait events, overall performance times and reducing i/o. Dan Fink -----Original Message----- Sent: Tuesday, November 19, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi One of my database showing hit ratio low (=75% approx).I increased the parameters.After last reboot hit ratio was looking great.Last reboot was last week.I am wondering again this ratio is 73% approx. How to fix this problem except Init.ora prameter change? Thx -Seema _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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.com -- Author: Fink, Dan 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).
