We have a slow procedure, have any suggestions/tools to tune the procedure instead of running the explain plan for every queries in the procedure?
Thanks
Blu
Printable View
We have a slow procedure, have any suggestions/tools to tune the procedure instead of running the explain plan for every queries in the procedure?
Thanks
Blu
how about modifying it to log how long each query takes to run, then tackling the longest running query first, etc
How can I capture the timing for each query in Procedure, am I able to set timing on ?
1) have a DBMS_OUTPUT with SYSDATE before and after the query.
2) If u can't see the OUTPUT. Have a dummy_process_table where you insert the start and end time
Thank you so much.
Blu