Home » RDBMS Server » Performance Tuning » database performance issue (oracle 11gr2)
database performance issue [message #613942] Tue, 13 May 2014 13:59 Go to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Dear Guru,

I am very new guy to database dba, but i have worked as a plsql developer.
I have given a assignemnt of dba , there is a database which is sometimes slow some time fine.

How to know what causing it to run slow.

Please give me some idea to that i can start to look into the system.

Please guide me

Re: database performance issue [message #613943 is a reply to message #613942] Tue, 13 May 2014 14:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You have been posting here for TWO years & still refuse to follow Posting Guidelines http://www.orafaq.com/forum/t/88153/0/

http://www.lmgtfy.com/?q=oracle+database+slow
Re: database performance issue [message #613948 is a reply to message #613943] Tue, 13 May 2014 15:13 Go to previous messageGo to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Thanks,

If you can let me know what rule i didn't follow so i would keep in mind. i have checked the 2nd link swan, but i want to know from where to start. if database is slow then how to check what is the bottele neck. where to check. Please donot get angry as i am not as intelligent as you. jest a little clue will help me to start my journey
Re: database performance issue [message #613953 is a reply to message #613948] Tue, 13 May 2014 21:40 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You have been posting here for TWO years & still refuse to follow Posting Guidelines http://www.orafaq.com/forum/t/88153/0/

where to start depends upon details specified Posting Guideline that you refuse to provide.

list few of the things which could slow down a database.
Previous Topic: Please help me execution plan is looking bad
Next Topic: LOV taking long time
Goto Forum:
  


Current Time: Thu Mar 28 05:41:34 CDT 2024