Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning ProC Cursors...

Re: Tuning ProC Cursors...

From: Willy Chua <willy_at_dfi.com>
Date: Fri, 01 May 1998 23:52:14 GMT
Message-ID: <354a5626.967438@client1.news.psi.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US