-
Yes that could be the reason. Increase the number of rollback segments.
-
since you are saying that Oracle.exe is taking 1.35 GB, I believe you Oracle is doing paging and swapping.
Do you have the means to find this at the OS Level ?
All the Parameters and Values dont look that bad to me,
are there any other application on that NT Server that are fighting for Memory ?
With a 300+ userbase, your DB must be a MTS configuration.
It that the case ?
-
Originally posted by patnams
With a 300+ userbase, your DB must be a MTS configuration.
It that the case ?
well well it is NOT a must
-
Hi,
But I already have rollback segments at 40.
Nop other application is running on Prod Server only One instance of Oracle and SAP Central Instance.
No it is not MTS config, an all 300 users doesn't interact directly with Oracle. There is only One user SAPR3 which have multiple sessions to interact with Oracle.
--------------------------
The Time has come ....
-
When I say MTS is a must, I meant at 300 Users you'd require a very large shared pool and processing capacity. Sorry about that...
It does not matter whether you have 1 user or 300 users. When refering to performance and # of users it invariably means # of sessions.
At 300 Sessions and with your Server Configuration, I'm sure there should be a significant difference when you switch to MTS.
Also 40 Rollback Segments ? Assuming 4 Trans per RBS, do you really have 160 Transaction at any point of time. Anyway RBS might not be an issue in this case.
Again, I'd go for an MTS if my userbase exceeds say 40 on a reasonably good server.
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
|