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

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.

Rajesh
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

Hi,

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:30011178429375

go through above link

regards
Taj
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 Dec 06 10:20:47 CST 2016

Total time taken to generate the page: 0.11423 seconds