I have a stored procedure which is quite huge.
It gives results but it tends to take some time.
I am trying to see if I can profile it. I have never done this profiling for tuning before.
Can someone explain me how I can profile the procedure?
I want to see which block in the procedure plsql, its taking time..
currently, I used like below:
stored procedure plsql code..
After using like this, I am having difficulty how to approach further.. after executing the procedure..