nsuleman wrote:
> 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.
The execution time of a stored procedure called by Crystal is exactly
the same as without Crystal. Contact me off-line and I can put you in
touch with a Crystal-PL/SQL expert that has written thousands of them.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Mar 30 2006 - 15:46:09 CST
