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, 2751🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...