Sometimes, for whatever reason, we face a situation where we must restart the database or the server that it is contained.
The biggest problem of this is that Oracle loses all the information that was in memory and starts very " cold " losing and needing to reparse:
- Execution plans
- Blocks in buffer cache
- Cursors in shared pool
- etc etc etc
It would be nice if there was a way to shutdown and save the SGA state information into disk and recover on the next boot, much similar to the " hibernation " concept.
Example:
- shutdown savestate;
And than on the next startup:
- startup recoverstate;
This would allow us to reboot our DB server and bring it to online as hot as it was before, with everything it had in memory.
Wouldn't it be great?
Thanks,
Rodrigo