Home » RDBMS Server » Server Administration » Sizing the SGA
Sizing the SGA [message #225686] Wed, 21 March 2007 00:01 Go to next message
Messages: 5
Registered: November 2006
Junior Member

I would like to know how to size the initial SGA size while creating the database.

What are the things that we have to consider for sizing the SGA?

If we have to consider if it is OLTP/DSS system, how many concurrent transactions, how many users and all, then provide me a detailed info, like if there are 100 users assign this much space, and so on.

Thank you in advance.

Re: Sizing the SGA [message #225709 is a reply to message #225686] Wed, 21 March 2007 01:52 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member



go through above link

Previous Topic: Recover using ARCHIVE files in Oracle 8i
Next Topic: Init Parameters to be set for Oracle 10g R2
Goto Forum:

Current Time: Tue Jun 27 09:13:32 CDT 2017

Total time taken to generate the page: 0.21069 seconds