EBS slowness

Posted by Roshan on Jul 12, 2016; 12:13pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-slowness-tp1147.html

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