RE: Sqlplus arraysize is like odbc ????
- From: "Boivin, Patrice J" <BoivinP@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Feb 2004 16:05:19 -0400
Thanks Igor... I played with that, changed it from 64000 to 100 million, no
appreciable improvement in performance.
Meanwhile when doing the same query through sqlplus, there is a HUGE
difference between arraysize 15 and arraysize 5000.
We are using the latest Oracle 8i ODBC Driver. ODBC trace is not turned on.
The network round trips are killing this application. Network latency,
database server taking too long to respond to subsequent requests for row
batches, I don't know at this point. But it takes too long for batches of
packets to get from the unix database to the application on the windows
server. Not the actual packets, they seem to travel fine. It's the round
trips that are taking too long.
We will do a test, I will trace the user session for waits while we capture
packets going between both servers at each end of the network trip.
If the delay is on the network we'll find it. If it was the unix server
taking too long to send the next batches of packets, how would I be able to
tell? Is there a specific wait inside Oracle to indicate this wait? And
how do I remove any delay there.
Patrice.
-----Original Message-----
From: Igor Neyman [mailto:ineyman@xxxxxxxxxxxxxx]
Sent: February 27, 2004 12:48 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Sqlplus arraysize is like odbc ????
There is "Prefetch Count" parameter in ODBC DataSource.
Is that what you are looking for?
Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Boivin, Patrice J
Sent: Friday, February 27, 2004 11:02 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Sqlplus arraysize is like odbc ????
Is there an equivalent for ODBC to the arraysize parameter in sqlplus?
Just curious.
Patrice
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
