on 08-04-2008 8:56 AM
Hi All,
I am facing the performance problem in a host where we have 3 hosts.
DEV, QAS and BWD.
In all the three instances we are facing the performance issues.
St06 Stats:
Physical mem avail Kb 16.777.216
Physical mem free Kb 258.048
Pages in/s 216
Kb paged in/s 1.728
Pages out/s 2.407
Kb paged out/s 19.256
Buffer Busy Waits: in ST04
data block 2.619 56.48
segment header 4.352.414 8.962.340
undo header 207 1 .37
undo block 57 380
Pls suggest me how to increase the performance.
Thanx in Advance
Kris
Edited by: kris on Aug 4, 2008 10:36 AM
Edited by: kris on Aug 4, 2008 10:43 AM
Hi Kris
Just to mention it, there is a special forum for [performance|; issues.
Kb paged out/s 19.256
This is bad, you should not be paging out. This most probably means you lack memory on the server. You will need to either:
- add more memory to the server
- lower some parameters on the systems, i suggest you check (it looks like you are running oracle) sga_max_size / db_buffer_cache / shared_pool_size on the databases. In SAP check em/initial_size_MB first. You might be able to reduce the settings on the DEV system to free some memory.
The buffer busy waits do not say much, without more information. We would need to know the time waiting on the database, and the ratio of buffer busy waits in relation to the overall wait events.
It might be the best to increase the memory, it is cheap, and never wrong
Best regards
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michael,
Thanks for the response.
My system is of 16GB physical RAM on which the 3 instances are running.
em/initial_size_MB = 3000 MB in 2 instances and 4096 MB in one instance.
Does reducing the sga_max_size / db_buffer_cache / shared_pool_size increase the performance?
Pls let me know which parameters are to tuned.
Regards,
Kris
Edited by: kris on Aug 5, 2008 8:45 AM
Edited by: kris on Aug 5, 2008 8:53 AM
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.