Xref: alice comp.databases.oracle.server:79493 Path: alice!news-feed.fnsi.net!netnews.com!europa.netcrusader.net!4.1.16.34!cpk-news-hub1.bbnplanet.com!news.gtei.net!news.mindspring.net!newsfeed.mindspring.net!firehose.mindspring.com!not-for-mail From: "crumedgeon" Newsgroups: comp.databases.oracle.server Subject: Re: Tuning db_block_buffer Date: Sat, 1 Jan 2000 16:57:02 -0500 Organization: MindSpring Enterprises Lines: 34 Message-ID: <84lt8f$dud$1@nntp9.atl.mindspring.net> References: <848ds2$i0o$1@nnrp1.deja.com> <386D6A7D.FCB5B939@yahoo.com> X-Server-Date: 1 Jan 2000 21:57:35 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Hello, - Which hit ratio are you calculating? (sounds remedial, but some folks use the v$ views the wrong way ;-) ) - What is your SGA size? - How much Physical RAM is on the box? It's hard to tell what the problem is without some more info... // cr OCP-DBA "faith" wrote in message news:386D6A7D.FCB5B939@yahoo.com... > I've seen the same thing happen. I changed the db_block_buffer parameter > on a database (8.0.5 on Solaris 2.7), and the hit ratio went from around > 85% down to 70ish. > weird. > > mayleel@my-deja.com wrote: > > > I'm running Oracle 8.0.5 on Solaris. > > > > I changed the db_block_buffer from 3200 to 4800,and my hit ratio went > > from 78-80% to 50% and dropping!!! > > > > Any ideas? > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. >