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, 943👍, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...