Skip to Main Content

Database Software

Option to save SGA buffers on shutdown ( hibernate the database )

Rodrigo Jorge DBAAug 10 2015 — edited Jan 11 2016

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.


- 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?



Post Details
Added on Aug 10 2015