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, 2157🔥, 0💬
Popular Posts:
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...