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:
⇒ SGA Setting Is Too Low in Oracle
⇐ Change System Global Area (SGA) in Oracle
2020-09-30, 2125👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...