How to find the runtime for a Stored Proc

I am not an Oracle Developer so please bare with me n the terminology. I am a Crystal Reports Developer and I was told to create Stored Procs instead of SQL Queries for the report. Everything is working great. Now my manager and the Business Users wants to know how much time does each Proc take. And the time that they want is only for Execution time.

What I mean is, they just want the time from the sec I start the Proc execution, till its complete (not including the time it takes to return data). I hope I made it clear.

As an example... Say I start the Proc at 10:00:00 AM.... at 10:00:05 AM I start getting records and the Proc is complete at 10:01:03 AM... Out of this... I would like to know the time difference between 10:00:00 AM and 10:00:05 AM which would be 5 secs.

I would really really appreciate if someone could help me figure that out. By the way, another important thing... ALL my Stored Procs have an OUT parameter of type... REF CURSOR. Crystal will only understand a Proc with that return type.

Thanks again to everyone for all your help. Received on Thu Mar 30 2006 - 14:50:35 CST