Collections:
Change Program Global Area (PGA) in Oracle
How To Change Program Global Area (PGA) in Oracle?
✍: FYIcenter.com
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:
2020-09-30, 935👍, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...