Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: low buffer_hit_rate !!!!!

Re: low buffer_hit_rate !!!!!

From: Joseph Sumalbag <joseph_sumalbag_at_bose.com>
Date: 1997/12/23
Message-ID: <34A02B39.40C8@bose.com>#1/1

Paul Osborn wrote:
>
> Dear Angelica:
>
> I find myself agreeing with another respondent who recommended that you
> run you sampling over a period of time while your application executes.
> You should see the db block buffer hit percentage increasing over time.
> Your - and actually any - sampling should:
> a) Be meaningful
> b) Accurate
> c) Consistent
> d) Take place over a period of time
> e) Be archived.
>
> [warning: self promotion on]
> Download the evaluation copy of DBAware from Menlo Software and use it to
> perform the sampling. Also, you can use the drill-down browser to examine
> which tables (if any) are being long-scanned]
> [self promotion off]
>
> Hope this helps,
> Paul
>
> Angelica Rivas wrote:
>
> > Hello to everybody!
> >
> > I have increased 300% the db_block_buffer parameter in the initSID.ora
> > file but the buffer_hit_rate is still too low, I have made biger 3
> > times (1500 each time) and restart the database, but it never has
> > moved from the low number.
> >
> > My statistics says between 70 to 80 percent daily...
> >
> > What can I do to increase this ratio? Is There another hide parameter
> > involved in this ratio?
> >
> > Thanks in advance, I will be so grateful...
> > Regards...
> >
> > Angelica Rivas
>
> ---------------------------------------------------------------
> Dear Angelica:
>
> I find myself agreeing with another respondent who recommended that
> you run you sampling over a period of time while your application
> executes. You should see the db block buffer hit percentage
> increasing over time. Your - and actually any - sampling should:
> a) Be meaningful
> b) Accurate
> c) Consistent
> d) Take place over a period of time
> e) Be archived.
>
> [warning: self promotion on]
> Download the evaluation copy of DBAware from Menlo Software and use
> it to perform the sampling. Also, you can use the drill-down browser
> to examine which tables (if any) are being long-scanned]
> [self promotion off]
>
> Hope this helps,
> Paul
>
> Angelica Rivas wrote:
>
> Hello to everybody!
>
> I have increased 300% the db_block_buffer parameter in the
> initSID.ora
> file but the buffer_hit_rate is still too low, I have made
> biger 3
> times (1500 each time) and restart the database, but it
> never has
> moved from the low number.
>
> My statistics says between 70 to 80 percent daily...
>
> What can I do to increase this ratio? Is There another hide
> parameter
> involved in this ratio?
>
> Thanks in advance, I will be so grateful...
> Regards...
>
> Angelica Rivas
>
>
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Attachment 2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Paul Osborn

Thanks for agreeing with my views ... Merry Christmas !

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================
Received on Tue Dec 23 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US