Re: Buffer cache hits %

From: Kekko <dini.f_at_adr.it>
Date: Thu, 15 Jul 1999 14:30:56 +0200
Message-ID: <378DD47F.3F388A07_at_adr.it>

1) Try to cache the most queried tables.
2) Check if indexes are useful.
3) Check if indexes are used.
4) Analyze the queries.
5) Analyze the chained and migrated rows.
6) Check the fragmentation of the tables.

It's sufficient.
Ciao, Kekko

Kevin Gillins wrote:

I have a question about the buffer cache hits ratio we are experiencing. We are on 7.3.3.5 database using 10.7 oracle apps most all products.  Apx 100+ users.The database size is apx 40 gig.  We are on HP 4 processors with 2.5 gig memory.There are 2 instances both the same size (prod and test).  The shared pool is setat 250,000,000 running 6 db writers.  The production instance is on EMC disks. My main question is the buffer cache hit% is sitting at 90% in general.  Is this good, bad orreal bad.  I want to get a feel.  I have tried increasing the shared pool and db_block_buffers. What other settings if any would improve this statistic.  What stats could I check to seewhat contributes to the 10% miss? Your suggestions and answers are appreciated. 
--

Kevin Gillins
Management Information Consulting
Boston Office
978-887-3300  

Received on Thu Jul 15 1999 - 14:30:56 CEST