RE: Buffer cache hit very low...!!!

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Wed, 14 Sep 2005 10:16:36 -0400
Message-ID: <A2C7821363A0544987988F6BCCE941B5060800@pegasus.lawaudit.com>

Why would he crank up anything? Is there a problem? DBCHR is low according to Joan Rivers, so what? Instead of worrying about DBCHR, you should give a call to GEICO. It will have the same effect on your database, and it will save you some money on car insurance.

--

Mladen Gogala
Ext. 121

-----Original Message-----

From: Michael McMullen [mailto:ganstadba_at_hotmail.com] Sent: Wednesday, September 14, 2005 8:39 AM To: chiragdba_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Buffer cache hit very low...!!!

40 Gb database with a 250Mb SGA. What is your db_cache_size? What are you running on? I would crank that db_cache_size somewhere close to 2Gb and then never worry about it again.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 14 2005 - 09:19:03 CDT