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.

.

Relevant Pages

  • Timeout fixed by recompile
    ... 200+gig db with 3 databases and hundreds of ... Its sql server 2000 and asp.net 1.1. ... one of our stored procs where it decides it will no longer complete ... We have thousands of users and this proc is run constantly. ...
    (comp.databases.ms-sqlserver)
  • Re: Modelers / code generators
    ... > dynamic SQL versus stored procs. ... extensive calculations on a lot of data, often this is done better in the ... >> a proc with another one, requires you to remove the old proc, however that ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to find the runtime for a Stored Proc
    ... I am a Crystal Reports Developer and I was told to create Stored Procs ... they just want the time from the sec I start the Proc ... touch with a Crystal-PL/SQL expert that has written thousands of them. ...
    (comp.databases.oracle.server)
  • Re: How to tell if a stored proc included a Select statement
    ... CREATE PROC mysp_comment @comment varchar ... EXEC mysp_Comment 'sp_1 follows' ... > there are stored procs called. ... can the calling sproc know if the called sproc populated a result ...
    (microsoft.public.sqlserver.programming)