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, 301👍, 0💬

Popular Posts:

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...

Difference Between G...

What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...