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.

 

SGA Setting Is Too Low in Oracle

Change System Global Area (SGA) in Oracle

Introduction to Oracle Database 10g Express Edition

⇑⇑ Oracle Database Tutorials

2020-09-30, 2569🔥, 0💬