Oracle - Change System Global Area (SGA) in Oracle

Change System Global Area (SGA) in Oracle

Q

How To Change System Global Area (SGA) in Oracle?

✍: FYIcenter.com

A

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:

Log into the server home page as SYSTEM.
Go to Administration, then Memory.
Click Configure SGA.
Enter the new memory size: 32
Click Apply Changes to save the changes.
Re-start your server.

⇒Introduction to Oracle Database 10g Express Edition

⇒⇒Oracle Database Tutorials

2016-10-17, 370👍, 0💬

Popular Posts:

Error: Imported Tabl...

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

Is SQL Server Transa...

Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

Downloading and Inst...

Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...