Oracle - Change Program Global Area (PGA) in Oracle

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, 466👍, 0💬

Popular Posts:

AND, OR, XOR, and NO...

What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...

DROP_EXISTING - Recr...

How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

sys.sql_modules - Ge...

How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...

CHARINDEX() and SUBS...

How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...