Re: Cache Hit Ratio

One option you could experiment with would be to write and execute a script on startup that will cycle through and touch all of the relevent tables you are concerned with. Another option would be to use hot backups. Also, for small lookup type tables you may want to check out the cache option (this could also be done in a startup script along with pinning of packages, procedures, etc).

M.Landa

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?
Received on Tue Jan 06 1998 - 00:00:00 CST