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, 1774👍, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...