Hi,
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:
storedprocedure()
variables....
x integer;
begin
x:=dbms_profiler.start_profiler('Test Profiler');
stored procedure plsql code..
x:=dbms_profiler.flush_data;
x:=dbms_profiler.stop_profiler;
end;
/
After using like this, I am having difficulty how to approach further.. after executing the procedure..
Thanks
Aeddy.
ASKER
I have one question though. I am trying to profile one of the stored procedures. when I run for the first time using the profiler it takes some time to run.
I just ran again to see if it takes the same time, but its extrememly fast during subsequent runs.
Also, if I run during day time at work the procedure runs little slower.
When I come home and run it, remotely connecting to my office pc, it runs much faster.
I am having difficulty to profile the procedure as I am little confused, as the execution times differ..
Any suggestions please..