Hi guys,
I know that after each DB restart the buffer cache and also the shared pool will be reset (same result of ALTER SYSTEM FLUSH SHARED_POOL and ALTER SYSTEM FLUSH BUFFER_CACHE)
For this reason, after the restart we have worse performance due to phisical disk IO needed and execution plan to reparse for each statements.
There is a way to store the information of the buffer cache and also the execution plans before the server restart in order to "refill" the data buffer later (after restart)?
We have an Oracle Server on AWS (versione 11.2.0.1) and we need to perform a restart often due to maintenance (keep AWS instance snapshot), so we lost all the data block cached and after restart the performance of hosted APPS was slower.
It is possible to store information in order to re-execute SQL and put back the data cached into buffer ?
Please help me
P.S: Sorry for my english sintax