database performance problem

[Arsalan]

Sir.

I have production database in oracle 11g and application design with oracle 10g forms
so some time client compine due to db is very slow kindly how to check to root problem on this.

kindly support me to solve the problem.


Arsala salem

[ErmanArslansOracleBlog]

Check OS layer first, check the load average, IO and everything.
Also look at the  db site.. Most of the time, we see the users waiting for the db actually.
For db performance analysis, start with AWR.
Create an AWR report which is built the AWR data produced during the problematic interval.
After creating the AWR report, analyze it and try to find the root cause there.

For understanding the AWR analysis, you can start by reading -> http://ermanarslan.blogspot.com.tr/2014/05/awr-analysis-part-1.html

[ErmanArslansOracleBlog]

Also, analyze the ASH report taken during the problematic interval.