title: oracle display for every stored procedure the execution time
body: <p>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.</p>
  
  <p>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).</p>
  
  <p>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.</p>
  
  <p>Any idea?</p>
  
  <p>I'm not a dba, so I don't have many rights on the database, I'm just a regular user.</p>