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, 2262👍, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...