Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

High user input output (I/O) and physical reads

611280May 18 2010 — edited May 20 2010

Hi guys

Recently we have noticed that our database performance degraded significantly. as we looked around in grid control we noticed that the user IO and Physical reads are really high which cause the database to be laggy.
at first we thought it was memory problem, so we added 2gb to sga. we have set sga to be automatic and it's been like this for the past 2 years.

how do i trouble shoot this problem. i haven't found any troubleshooting guide for it yet.
please instruct me on how to solve it

database: 10.2.0.4 sparc

regards
Sina

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2010

Added on May 18 2010

#general-database-discussions

9 comments

8,348 views