Re: EBS slowness

Posted by ErmanArslansOracleBlog on Jul 12, 2016; 1:04pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-slowness-tp1147p1149.html

how many concurrent manager process defined for standard manager?
There are lots of Standard manager queries.
Consider tuning that count. You may decrease it accordingly.

There is not an obvious performance problem in db , IO is good, db time is not so high.But those concurrent queries may cause the latch and concurrency related waits in the database. ( top waits are concurrency waits as described in your awr)

As for the application tier, if you didnt tune the oacore already, increase its heap size and restart the oacore managed server. Also check apps tier OS for cpu and memory usages.
I dont think there is a need for adding additional oacore servers at the moment, as you have 500-600 db sessions , so this means no need for extra oacore servers.


So, if I summarize,

tune the conc manager process counts.
tune the oacore server heap size.