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, 4702🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Select All Columns of All Rows from a Table in Oracle? The simplest query statement is the on...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...