Re: Tuning ProC Cursors...

From: Hayden Worthington, Inc. <hayden_at_mindspring.com>
Date: Mon, 11 May 1998 10:28:46 -0400
Message-ID: <35570B1D.91A4E9CF@mindspring.com>

Willy,

 In our performance tuning document library there's a whitepaper on  Optimizing OCI that be of interest to you.

  http://hayden.home.mindspring.com

 Peter

> > 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

---

Hayden Worthington, Inc.       Oracle Performance Tuning
5696 Peachtree Parkway         www.mindspring.com/~hayden
Norcross, Georgia 30092        White Papers, Scripts, etc.

800 844-0497 Received on Mon May 11 1998 - 09:28:46 CDT