Re: Can I know how long took a select into a cursor ?

Have you looked at the explain plan? Have you tried tracing the session? Doing this may give you insight as to performance of the statement you're looking at. I don't think it's a matter of how long it takes the cursor to execute unless you're hitting some documented bug in Oracle. But rather, I think that it's a problem with performance of the statement itself. So, I would look at the explain plan of the statments it runs, i.e. run a sql trace on the code.

HTH,
Pete's

Frederic Payant <fpayant_at_freesurf.fr> wrote in message news:<0sqhevsqrbosk3v1q7nlbfp6j7eerkuhp5_at_4ax.com>...
> Hi,
>
> [ solaris 8 Oracle Enterprise 8.1.7.0 ]
>
> Is there any way to know how long took a cursor to execute ?
> I 've a binary program in which developer 1st open a cursor for X
> first rows (where rowid < X) then for each fetch, call some
> proprietary OCI which do some job.
>
> I would like to know if it is possible to know how long it takes to
> fill the cursor (ie how long it is to select X first rows) ?
>
> Naturally,it's impossible to modify any part of code, so any info will
> have to be got across Oracle's views.
>
> Thanks a lot and have a nice day
> Regards
> Frederic PAYANT - junior DBA ;-)
Received on Fri Jun 13 2003 - 08:54:37 CDT