EBS R12 Slowdown

[neldyan14]

Hi Erman,

Good Day! Kindly give me some recommendation on how to improve the performance of my EBS instance. Please see attached files.

awrrpt_1_18730_18734.html
Oracle_Enterprise_Manager_(SYS)_-_Database_Instance_F1_-_Google_Chrome.jpg

[ErmanArslansOracleBlog]

You have high counts for "qmn task queue latch"
You have high counts for "cache buffer chain latch"
Your system is bound CPU and IO bound.


You need to concantrate on the sql listed in SQL ordered by Gets section.
For example this one -> d0uqq8xd0rms2
Read Buffer Pool and SGA Target Advisory sections as well..

How to Read Buffer Cache Advisory Section in AWR and Statspack Reports. (Doc ID 754639.1)
Troubleshooting 'latch: cache buffers chains' Wait Contention (Doc ID 1342917.1)

1)This qmn latch can be related with Goldengate.. Do you have Goldengate configured?
2)What is your OS version?

[neldyan14]

Hi Erman,

We don't have goldengate.

OS version is. Linux version 3.8.13-16.2.1.el6uek.x86_64 ([e-mail]) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC) ) #1 SMP Thu Nov 7 17:01:44 PST 2013

Thanks

[ErmanArslansOracleBlog]

Okay , you don't have Goldengate, but I wrote you about the other things as well.
Please read my previous reply and check your system accordingly.