Oracle Thin Driver Vs. OCI Driver

667481 members! Sign up to stay informed.

Threaded replies

·	Oracle Thin Driver Vs. OCI Driver by Sunil Chandran on Fri Mar 09 16:34:06 EST 2001

·	Oracle Thin Driver Vs. OCI Driver by Dave Wolf on Sun Mar 11 15:08:41 EST 2001

·	Oracle Thin Driver Vs. OCI Driver by Dat Truong on Wed Mar 14 09:24:25 EST 2001

·	Oracle Thin Driver Vs. OCI Driver by Sunil Chandran on Wed Mar 14 18:26:07 EST 2001

·	Oracle Thin Driver Vs. OCI Driver by Mike Perham on Sat Mar 17 15:14:59 EST 2001

·	Oracle Thin Driver Vs. OCI Driver by Ben Flaumenhaft on Mon Mar 19 16:31:29 EST 2001

·	Oracle Thin Driver Vs. OCI Driver by Ramesh Ramachandran on Mon Mar 19 18:22:08 EST 2001

·	Oracle Thin Driver Vs. OCI Driver by MUS on Wed May 05 10:23:39 EDT 2004

·	Oracle8i - JDBC Performance by xu li on Wed Jul 09 23:41:53 EDT 2003

·	Oracle8i - JDBC Performance by MUS on Wed May 05 10:21:44 EDT 2004

	Message #15405 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle Thin Driver Vs. OCI Driver Posted by: Dave Wolf on March 11, 2001 in response to Message #15342 In my experience from many different clients, you are MUCH better off using the thin driver. The issue is the OCI driver isnt thread safe and you will find that 1) this causes the driver to be slower then the thin driver and 2) this makes the OCI driver alot less stable. Your first choice was right, stick with the thin driver. Dave Wolf Internet Applications Division Sybase

	Message #15656 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle Thin Driver Vs. OCI Driver Posted by: Dat Truong on March 14, 2001 in response to Message #15405 But there's a fail-over issue, that OCI driver can preserve a state of it's clients, where as the thin driver cannot.

	Message #15716 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle Thin Driver Vs. OCI Driver Posted by: Sunil Chandran on March 14, 2001 in response to Message #15405 Hi Dave, Thanks for your response. I have heard that Thin drivers have problems when they are used in a clustered application server environment with multi-threaded programs using database connections. Also, any idea where I can find some documentation on performance comparisons between the two. Thanks, Sunil

	Message #15948 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle Thin Driver Vs. OCI Driver Posted by: Mike Perham on March 17, 2001 in response to Message #15405 That's interesting - my experience with the 8.1.5 drivers was the opposite. I never noticed any bugs in either driver but did come to the conclusion that the OCI driver was 20-30% faster than the thin on Solaris 2.5. This was on the production machines for living.com (now deceased) - with several thousand users hitting the site at a given time via Dynamo 4.5. I guess YMMV. Mike

	Message #16062 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle Thin Driver Vs. OCI Driver Posted by: Ben Flaumenhaft on March 19, 2001 in response to Message #15948 Another issue with partially native drivers is that they're usually more difficult to install (you don't just add a .jar file to your lib directory or classpath and change your JDBC connect string). They also tie you to one deployment platform. Worth keeping in mind ... Regards, Ben Flaumenhaft Principal, Sidelight Consulting http://www.sidelight.com

	Message #16071 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle Thin Driver Vs. OCI Driver Posted by: Ramesh Ramachandran on March 19, 2001 in response to Message #16062 Hi, I am using Solaris 2.8 Oracle 8.1.7 JDK 1.3.1 and I found that Thin performs better at higher Transaction rates compared to OCI and uses less CPU. But Oracle processes uses more CPU to handle these requests. Also, its much easier to configure that the OCI driver. I have reverse experience with earlier versions of oracle and solaris. Thanks, -Ramesh Sun Microsystems.

	Message #88724 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle8i - JDBC Performance Posted by: xu li on July 09, 2003 in response to Message #15342 http://technet.oracle.com/tech/java/sqlj_jdbc/pdf/jdbcperf.pdf

	Message #120759 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle8i - JDBC Performance Posted by: MUS on May 05, 2004 in response to Message #88724 I think this will help you resolve the issue; 1) http://www.csee.umbc.edu/help/oracle8/java.815/a64685/getsta1.htm 2) http://sales.esicom.com/sales/oracle/java.816/a81354/overvw2.htm 3) http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci920399,00.html 4) http://www.cis.upenn.edu/~cis550/TRASH/JDBC_doc/jdbcoci3.htm

	Message #120761 Post reply Post reply Post reply Go to top Go to top Go to top

Oracle Thin Driver Vs. OCI Driver Posted by: MUS on May 05, 2004 in response to Message #15405 I think this will help you resolve the issue; 1) http://www.csee.umbc.edu/help/oracle8/java.815/a64685/getsta1.htm 2) http://sales.esicom.com/sales/oracle/java.816/a81354/overvw2.htm 3) http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci920399,00.html 4) http://www.cis.upenn.edu/~cis550/TRASH/JDBC_doc/jdbcoci3.htm

Recent active threads Recent active threads Recent active threads

More More More

	IPhone App Development with JSF
	Web as the Platform: Day 1 at the Ajax Experience
	Need help for login page using java servlet
	Stateful Webservice in java
	SAP Asks Sun/Oracle to Let Java Be Free
	Registration for TheServerSide Java Symposium Las Vegas now open
	Use Sun SPOTs as your build canary
	AspectJ In Action Published; Sample Chapters Posted on TSS
	WSO2 goes all RESTy
	Return to previous view after user action

More active threads »

Top posters of the weekTop posters of the weekTop posters of the week

This list contains the members who have made the most posts in all forums over the last 7 days: Dan Evans James Watson William Louth sara foster Chief Thrall

Hot threads Hot threads Hot threads

More hot threads More hot threads More hot threads

Object pooling is now a serious performance loss

Brian Goetz continues to lift the lid and peak into the inner workings of Java in Java Urban Performance Legends. In this article he exposes the fallacy behind some of the more common performance myths found in the annals of the JVM.
(93 comments, last posted February 06, 2009)

Beyond Java

Bruce Tate, author of Better, Faster Lighter Java and Bitter EJB has come out with a new book called Beyond Java. Bruce has an epiphany about the future of software development. Does it include Java?
(770 comments, last posted September 23, 2009)

Three forms of AJAX: solid, liquid and gas.

Looks like today AJAX concept have several interpretations. We can distinguish different approaches of AJAX integration. Can they co-exist within the same application? Can we talk about layered AJAX integration?
(68 comments, last posted May 08, 2008)

Design-Time API Promises to make Java more like VB

Artima has published a short article describing the Design-Time API for JavaBeans, which was recently approved as JSR 273. This API promises to bring VB-like ease to Java development, but may face a cultural bias among Java developers who tend to think more in terms of class libraries than components.
(225 comments, last posted November 19, 2009)

Will Sun be that target of a management buyout?

There is plenty of speculation today regarding a potential buyout of Sun Microsystems by Scott McNealy and Silver Lake Partners. How would privatization of Sun affect Java?
(16 comments, last posted May 15, 2009)

More hot threads »

Java Solutions

Oracle Thin Driver Vs. OCI Driver

Threaded replies