EBS slowness

[Roshan]

Hi,

we have noticed the application instance is slow(login, forms...)

I did an AWR report analysis and found that an sql id: b6mcn03jvfq41 showed high cached buffers. I have checked with the development team, they are saying the SQL query is from standard EBS application.

Is there some tuning I can do on the database?

awrrpt_1_testprod_10_1038.html

Thanks,
Roshan

[Roshan]

The CPU and RAM seems to be ok. I think I need to tune oacore/forms
CPU.PNG
memory1.PNG
memory2.PNG

[ErmanArslansOracleBlog]

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.

[Roshan]

Thanks Erman. I tuned oacore_server. It is ok now.

[ErmanArslansOracleBlog]

Good.