| cache data problem [message #65525] |
Wed, 13 October 2004 12:46  |
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  |
Frank
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.
hth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
