11 thoughts on “Performance tuning SQL queries in Oracle”

  1. Nice talk. DB Performance is still a bit of a mystery to me. I usually log the times that each query takes and if they are long, then I’ll point them to an expert like yourself. At least I will know who to ask for advice next time I write a horribly slow DB query :-)))

    Heinz

  2. With P6Spy, you have a JDBC driver that logs the times automatically. The beauty is that it is database independent, so I can apply the same technique whether the customer is using Sybase, DB2, Oracle, MySQL, etc. Once we have discovered that the database is indeed a bottleneck, we would pass that information to someone like you who can then run a detailed trace. Thanks for the link for Oracle though 🙂

  3. Hi Hardeep,

    I found your session quite informative, i want to learn how explain plan works and how can I understand explain plan and the terminology used in it, to tune my code. is this something you can help? any article ? book ? examples ?

  4. Hi Hardeep,

    Nice to see your blog and impressive articles. I am looking for PLSQL perfromance quide for Oracle from basic to Advance which will help in Live Scenarios.

    Regards,

  5. Hi,

    I would like to know how to find out why the query running slow? What are the steps to look for finding out the reason for slow running query?

    1. To see why the query is running slow, the first step is to review the plan Oracle is using to execute it. Look for the ‘explain plan’ command. Once you have the plan review it to see bottlenecks – is it using appropriate indexes etc. Needs some bit of experience, gets easier when you get the hang of it.

      There was a problem with the video but I have fixed it, please watch it – will give you some starting ideas. Also review the PDF document available at http://blog.2cent.me/computer/20130410/oracle-performance-tuning/.

Leave a Reply

Your email address will not be published. Required fields are marked *