Hi all.

I'm working on a stored procedure. Inside this one, there are many call to the other stored procedures. There are a bunch of them.

I was wondering if there is a option to be able to have the execution time of every stored procedure involved, every function (with a start and end time, ior something like that).

The idea is that I need to optimise it and I should touch every part, and since I not sure where is the longest execution time, is a bit difficult. And after a modification I would like the see the hole process if it's shorter or not. If I call the procedure from unix, using sql plus, I have no log. If I call it from TOAD, it's blocked until the end.

Any idea?

I'm not a dba, so I don't have many rights on the database, I'm just a regular user.

Thanks for any advice.

C.C.