Home » RDBMS Server » Server Administration » DB Slow (ora 10.2.0.4)
DB Slow [message #437433] Mon, 04 January 2010 07:12 Go to next message
sahadba
Messages: 59
Registered: September 2009
Location: Pune
Member

Hi Experts,

I am an Oracle DBA, relatively new to this Profile.
In our project we get repeated complaints from user that DB is working slow...

What are the steps to be taken when we get such requests.

I check the server memory
Alert Log files
Back up logs et all

Please guide me in this regard..
Re: DB Slow [message #437439 is a reply to message #437433] Mon, 04 January 2010 07:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Start here
http://www.orafaq.com/forum/t/84315/42800/
Re: DB Slow [message #437440 is a reply to message #437439] Mon, 04 January 2010 07:23 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
When was the last time your statistics updated?
Check/google dbms_stats.
Previous Topic: Unable to re-install oracle 11g rel2 on same oracle_home path
Next Topic: Inactive session
Goto Forum:
  


Current Time: Sun Dec 04 12:39:57 CST 2016

Total time taken to generate the page: 0.14823 seconds