Re: Cache Hit Ratio

I'm not sure but you could be talking about the pre_page parameter on your init<SID>.ora ..
Set it to TRUE
.. This will help you achieve a higher hit ratio faster although it may cause your database to take sometime when you restart it .
I hope this helps

Someone wrote:
>
> In my current setup I always bring down oracle for a cold backup every
> night. Of course, when Oracle starts up the cache hit ratio is low as
> the tables get read back into memory. I seem to recall a long time ago
> that someone in this newsgroup asked whether you could load tables back
> into memory or even perhaps take a snapshot of the SGA and reload it
> when it restarts. Seems unlikely but hey, anyone have any ideas?

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