-
New Server with 4Gb memory
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
-
are you deploying your application through 10g apps server in this machine alone(single-node)?
---------------
-
Last edited by davey23uk; 08-11-2006 at 11:39 AM.
Reason: Incorrect link
"What is past is PROLOGUE"
-
IBM AIX Server with 4Gb mem
Too low for your requirement.
Tamil
-
-
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
Last edited by yxez; 08-13-2006 at 09:54 PM.
-
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.
---------------
-
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)
"What is past is PROLOGUE"
-
Originally Posted by 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)
So what is your recommendation for SGA according to what info she have gave us so far?
---------------
-
Originally Posted by reydp
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.
"What is past is PROLOGUE"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|