New Server with 4Gb memory

[yxez]

Hi Friends,

We bought a new IBM AIX Server with 4Gb mem, dual proc
for our new applications. We will be using oracle 10g.
We will be having initial users of 100. What will be the size of
my initial SGA for 100 users?
If we increase it to 1000 what will be the appropriate SGA?
Is it dependent of the number of users? or its will just
dynamically grow and adjust itself (self tuning)

Thanks a lot

[reydp]

are you deploying your application through 10g apps server in this machine alone(single-node)?

[dbasan]

Know your self from Metalink doc https://www.metalink.oracle.com/meta...p_id=1008866.6

[tamilselvan]

IBM AIX Server with 4Gb mem

Too low for your requirement.

Tamil

[marist89]

Too low for your requirement.

Tamil

[yxez]

Thanks for the response

To papa rey (nabuhay ka, long time no see) ....this box is for the db server only,
the apps middle tier has its own server.

To dbasan, sorry i can't access the link anymore :( ...have not
renewed license maintenance support.

By the way, if the config is to low for our requirement, how many
users can be accmodated in this db server then?

Do I approximate(as rule-of-thumb) that each user will eat-up 4Mb?
So 4000Mb/4Mb = 1000

Thanks

[reydp]

hi yxez. your machine is IBM eSeries p Model with AIX 5L o.s. with 4Gbyte mem should just be enough for 100 users. I did have one setup for Oracle Apps 11i(11.5.10) where db server has basically the same with your machine. And it just doing good, I'm not sure though now, if the requirement stays the same. set the sga target at least half of your physical memory and observe it from there.

[dbasan]

Instead of going by approximation,

SGA= (DB_CACHE_SIZE + DB_KEEP_CACHE_SIZE + DB_RECYCLE_CACHE_SIZE + DB_nk_CACHE_SIZE
+ SHARED_POOL_SIZE + LARGE_POOL_SIZE + JAVA_POOL_SIZE + LOG_BUFFERS)

[reydp]

Instead of going by approximation,

SGA= (DB_CACHE_SIZE + DB_KEEP_CACHE_SIZE + DB_RECYCLE_CACHE_SIZE + DB_nk_CACHE_SIZE
+ SHARED_POOL_SIZE + LARGE_POOL_SIZE + JAVA_POOL_SIZE + LOG_BUFFERS)

So what is your recommendation for SGA according to what info she have gave us so far?

[dbasan]

So what is your recommendation for SGA according to what info she have gave us so far?

I have given her home work, she would come to know when she does it.