cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Issue in multiple Instances on a Host

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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