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, 1889👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...