1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to diagnose a oracle procdure which is slow

Discussion in 'SQL PL/SQL' started by ashish kumar, Jan 29, 2014.

  1. ashish kumar

    ashish kumar Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    A Java batch program calls many oracle procedures and it takes 5 min to complete.
    Not it is taking 3 hrs.
    how to identify a which procedure is taking more time and tuned it ????