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

Popular Posts:

Import One Table bac...

How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

MySQL Database Tutor...

Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

Error: Lock Wait Tim...

What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...