1.

Can You Change Shared_pool_size Online?

Answer»

YES. That's POSSIBLE.
SQL>alter system set shared_pool_size=500M scope=both;
System altered.
It's a LOT QUICKER to bounce the instance when changing this.

YES. That's possible.
SQL>alter system set shared_pool_size=500M scope=both;
System altered.
It's a lot quicker to bounce the instance when changing this.


Discussion

No Comment Found

Related InterviewSolutions