Change Program Global Area (PGA) in Oracle

Q

How To Change Program Global Area (PGA) in Oracle?

✍: FYIcenter.com

A

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.

 

Introduction to Oracle Database 10g Express Edition

⇒⇒Oracle Database Tutorials

2016-10-17, 157👍, 0💬