What is Dynamic SGA?What is the advantage of Dynamic SGA?

hmounir

 Profile Answers by hmounir Questions by hmounir

• May 3rd, 2010

Dynamic SGA allows to change the size of the buffer cache, the large pool, the shared pool and the process private memory on the fly, that is without shutting down the instance.

doza_kasf

 Profile Answers by doza_kasf Questions by doza_kasf

• May 1st, 2010

Dynamic SGA allows to change the size of the buffer cache, that is without shutting down the instance.

Answer Question  Select Best Answer