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