[Oracle-l] Oracle 9i performance

[Oracle-l] Oracle 9i performance

	Smith, Ron L.
	Feb 16, 2005 at 4:37 pm

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

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Follow ups

Ray Stell: Use the trace facility: http://download-east.oracle.com/docs/cd/B10501_01/network.920/a96580/toc.htm Ray Stell stellr_at_vt.edu (540) 231-4109 28^D -- http://www.freelists.org/webpage/oracle-l
Justin Cave (DDBC): 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 Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC
Martic Zoran: Hi Ron, The first thing is what is slow for you? Currently for me is very slow that I can do only few thousands inserts into Oracle while some other so called in-memory databases can do it much more under certain cisrumstances. We are using OCI and ODBC with Oracle very successfully. For data transfer between Oracle and the client you need to use all of these: - prefetching (I used it from 7.3, cannot remember earlier) - array binding/fetching, where you can pass to and from the database arrays

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 1 of 4 \| next ›

Discussion Overview

group	oracle-l @
categories	oracle
posted	Feb 16, '05 at 4:37p
active	Feb 17, '05 at 3:27a
posts	4
users	4
website	oracle.com

font	variable	Hotkey: f
user style	avatars	Hotkey: a

[Oracle-l] Oracle 9i performance

Search Discussions

Discussion Posts

Related Discussions

4 users in discussion