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.

Database got too slow suddenly

780914Aug 11 2010 — edited Aug 12 2010

Hi All,
I am new to DBA activities. Here, the development database suddenly got very slow after executing few update statements.
Oracle Database version is 9.2.1.0 running on 32 bit windows. Its net size is around 5.5 GB.
SGA allocation - 304 MB

Network configuration is same as before. I also analyzed the tablepsace configuration, which I found to be correct and appropriate.

Can somebody guide me or provide info/link? How to start investigating the performance issue, what are the key areas which can affect database performace?
Also, if any more info is required, please let me know .

Thanks to you all !!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2010

Added on Aug 11 2010

#general-database-discussions

10 comments

2,057 views