RE: Sqlplus arraysize is like odbc ????
- From: "Boivin, Patrice J" <BoivinP@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 01 Mar 2004 08:22:08 -0400
Thanks.
We are using the latest ODBC driver from Oracle.
Pre-Fetch doesn't make much of a difference for us.
Patrice.
-----Original Message-----
From: Hemant K Chitale [mailto:hkchital@xxxxxxxxxxxxxx]
Sent: February 28, 2004 11:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Sqlplus arraysize is like odbc ????
From the ODBC 8.1.7.7 Release Notes :
NEW FEATURES
ODBC 8.1.7.7.0
Implemented an internal pre-fetch cache to improve the performance
of fetching data, especially for applications
which are fetching one row at a time. The size of the cache is a
data source configuration option.
Depricated the 'Pre-Fetch Count' data source configuration option
and replaced it with the option 'Fetch Buffer
Size'. The 'Fetch Buffe Size' option is used to specify the size
of the internal pre-fetch cache. The default is 64,000
bytes.
Significantly improve the performance of fetching rows from a keyset cursor
when fetching a single row at a time.
(Bug2257280)
At 04:05 PM 27-02-04 -0400, you wrote:
>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
>-----------------------------------------------------------------
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 24-Jan-04}
"Failure is not an option.
It comes bundled with the software
[or hardware, as the case may be]"
----------------------------------------------------------------
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:
