RE: Oracle 9i performance
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <rlsmith@xxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Feb 2005 14:56:51 -0700
It's certainly possible. =20
Unfortunately, it's been a while since I was in the OCI innards here,
but I recall that there was an issue where the OCI 7 approach to
prefetching did not work with Oracle 9 databases. This made
applications send a separate network request for every row, unless the
client application was specifically written to do array fetches (which
most ODBC applications are not designed to do).
Justin Cave <jcave@xxxxxxxxxxx>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Ron L.
Sent: Wednesday, February 16, 2005 4:35 PM
To: oracle-l
Subject: Oracle 9i performance
We have an application running on an NT server using an Oracle 7.2 V2.5
ODBC connection to talk to a new 9.2 database on a Linux server. The
application transfers a lot of data back and forth. The performance is
pretty slow. Could it be caused by the old ODBC and SQL*NET on the
application server?
Thanks!
Ron
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
