Home » RDBMS Server » Performance Tuning » cache data problem
cache data problem [message #65525] Wed, 13 October 2004 12:46 Go to next message
gulshan
Messages: 19
Registered: January 2004
Junior Member
hello everybody,

When we shut down instance all the data in cache flushed out and at the time of startup, no statement in library cache or no data in all cache. Only when database warms up then only in that case we should need to calculate buffer cache hit ratio.

Can anybody tell me that Is there any way to store all the cached data in the caches will automatically stored at the time next instance starts up as it was earlier before shuting down, so the hit ratio increases all the time........

Thanks in Advance..........
Re: cache data problem [message #65526 is a reply to message #65525] Thu, 14 October 2004 02:55 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You could pin important packages in your SGA. If this is so important to you, do not shutdown your database. Shutting down should not be a regular action IMHO.

hth
Previous Topic: Removing caching in Oracle
Next Topic: URGENT:-Query not performing well
Goto Forum:
  


Current Time: Sat Sep 19 01:17:26 CDT 2020