Re: Cache Hit Ratio

I'm sorry the parameter name is not PRE_PAGE but PRE_PAGE_SGA ! Set it to true and your SGA will be pre-paged causing your DB to reach a higher hit ratio quicker !

Ciao !

Joseph Sumalbag wrote:
>
> 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                           |

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