Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle ODBC driver Pre-fetch problem with 8.1.78 Driver

187722May 2 2003 — edited May 5 2003
Hi all,

I'm having a strange problem with my Oracle ODBC Driver. I had the Oracle 8.1.74 ODBC driver on my system, and I upgraded to the 8.1.78 driver. After doing this, I noticed that my network packet count has gone up doing simple queries. It seems with this driver, that the driver is not pre-fetching any data. I also noted that in the 8.1.78 driver that the prefetch count has been replace by a prefetch buffer size. Is there a bug with the 8.1.78 ODBC driver ?
Or do I have to configure the Pre-fetch buffer size differently than the Pre-fetch count ? I've left the size at the default of 64000 - I assuming that means 64000 bytes = 64K.

Thanks,
Nick.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2003
Added on May 2 2003
5 comments
3,646 views