Home » RDBMS Server » Performance Tuning » cache data problem
cache data problem [message #65525] Wed, 13 October 2004 12:46 Go to next message
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
Messages: 7901
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.

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

Current Time: Sat Mar 02 16:27:27 CST 2024