R – Performance Tuning

oracle10gperformance

How can i check the Query running from long time & steps of tuning the query? (Oracle)

Best Solution

  1. Run explain plan for select .... to see what Oracle is doing with your query.
  2. Post your query here so that we can look at it and help you out.
  3. Check out the Oracle Performance Tuning FAQ for some tricks-of-the-trade, if you will.