| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sqlplus arraysize is like odbc ????
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_at_perceptron.com]
Sent: February 27, 2004 12:48 PM
To: oracle-l_at_freelists.org
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_at_perceptron.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Boivin, Patrice J
Sent: Friday, February 27, 2004 11:02 AM
To: 'oracle-l_at_freelists.org'
Subject: Sqlplus arraysize is like odbc ????
Is there an equivalent for ODBC to the arraysize parameter in sqlplus?
Just curious.
Patrice
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |