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: Oracle 9i lock file (lkDBNAME)
Next Topic: ORA-12560: TNS:protocol adapter error ???
Goto Forum:
  


Current Time: Sun Aug 20 16:12:50 CDT 2017

Total time taken to generate the page: 0.10644 seconds