Answers

Question and Answer:

  Home  Oracle Database Developer

⟩ How you change program Global Area (PGA) in Oracle?

Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. If you think your session will be short with a small amount of data, you should change the PGA size to 16MB by:

* Log into the server home page as SYSTEM.

* Go to Administration, then Memory.

* Click Configure PGA.

* Enter the new memory size: 16

* Click Apply Changes to save the changes.

* Re-start your server.

 130 views

More Questions for you: