Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning ProC Cursors...
On Fri, 01 May 1998 18:12:38 GMT, willy_at_dfi.com (Willy Chua) wrote:
>Hi All,
>
>I have opened mutiple cursors and have to walk thru them at a certain
>sequence. Unfortunately when I do these, the performance has
>slowed down significantly.
>I tried pinning( hold_cursor = yes and release cursor = no) and it
>still does improves not the performance.
>
>If each cursor are opened and timed individually. It goes thru each
>record pretty fast. But given the above scenario, the performance
>goes down big time.
>
>Thanks in advance for your help,
>
>willy_at_dfi.com
Received on Fri May 01 1998 - 18:52:14 CDT
![]() |
![]() |