Q
Manage Learn to apply best practices and optimize your operations.

How to set the size of SGA?

How can we set the size of SGA in an OLTP environment and what will be the minimum size of SGA by default when we create the database?

How can we set the size of SGA in an OLTP environment and what will be the minimum size of SGA by default when we create the database?
The SGA is defined for a database by setting multiple parameters in the init.ora file or spfile. Parameters that influence the size of the SGA vary by database version, so it depends whether you are using Oracle8i, 9i or 10g.

With respect to your question regarding the default size of the SGA, if you create your database with the Database Configuration Assistant (DBCA) and define your database as OLTP, it will recommend an SGA appropriate to that type of environment; however, you can adjust it accordingly. If you create your database manually with scripts, you will obviously have more control over the relevant parameters and be able to set them appropriately for your environment. You can view information about the SGA in the Oracle 10g Release 2 Administrator's Guide found here.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close