Collections:
Change System Global Area (SGA) in Oracle
How To Change System Global Area (SGA) in Oracle?
✍: FYIcenter.com
Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your server. If you are running this server just for yourself to improve your DBA skill, you should change the SGA size to 32MB by:
⇒ Change Program Global Area (PGA) in Oracle
⇐ Unlock the Sample User Account in Oracle
2020-09-30, 2153🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...