Tuning SQL Query

In 10g Linux platform, today i executed a query which takes 5 minutes to execute. I executed the same query the next day it took long time to execute, what will be the problem?how to identify it?tel me the solutions also.

Showing Answers 1 - 6 of 6 Answers

navin amarasiri

  • Jul 6th, 2012
 

Try some indexing...

  Was this answer useful?  Yes

basheer

  • Sep 25th, 2013
 

Might be sudden volume of surge in particular table.its required gather stats for this table. Or any change in db level or under layed object level

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions