Forum Stats

  • 3,874,702 Users
  • 2,266,767 Discussions
  • 7,911,956 Comments

Discussions

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

Rodrigo Jorge DBA
Rodrigo Jorge DBA Member Posts: 86 Bronze Badge
edited Jan 11, 2016 5:54PM in Database Ideas - Ideas

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

Rodrigo Jorge DBActriebtop.gunborneselFranck PachotkulikouskiRindbækSergey KlimovStefan AbrahamMatheus BoesingRainer StenzelSven W.sensoftberxMKJ10930279
16 votes

Active · Last Updated

Comments