How To Change Program Global Area (PGA)

Q

How To Change Program Global Area (PGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition

✍: 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.

2007-04-24, 4916👍, 0💬