As Tim said, look at the RowCacheSize, I have seen big speed gains by increasing this attribute.
On Wed, 2005-05-04 at 10:38 +0100, Tim wrote: > On Wed, May 04, 2005 at 02:18:02AM -0400, Steve Sapovits wrote: > > > > >I meant to also note that the job in question is all SELECTs -- > > >it only pulls data and does not update any tables. If the > > >"almost there" is known to cover SELECTs that would be good to > > >know. > > > > I did some reading and from what I can tell, Oracle's array > > interface would not have any effect on the type of query > > the job I'm being asked about is running. This jobs does > > SELECT queries with no placeholders, that result in large > > result sets. OCI array interface appears to only have an > > effect on repeated operations (such as inserts) that have > > different placeholder/bind values per execution -- not at all > > the case here. > > > > Can someone verify this observation? > > You are correct. > > Turn your attention to the RowCacheSize attribute. > > Tim. -- Scott T. Hildreth <[EMAIL PROTECTED]>
