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.
