Re: low buffer_hit_rate !!!!!

Angelica ,

  I would suggest that you leave the database running for a while before you do your hit/ratio sampling ..... The cache needs to load all the db blocks on memory as your users use the db before you could notice the difference of the changes that you make ...

And right after you startup you database see if the changes that you made is taking effect ...

try to type

   show parameters db_block_buffers

on the SQLDBA prompt or the server manager prompt ... and check if the value is the same as what you set up ....

If it is different then you might be editing the wrong initSID.ora file .... I got a developer who did the same and was puzzled until i showed him why ...

I hope this helps ....

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

-- 
================================================================
============================
| 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.                            
|
================================================================
============================