I own a book named “Expert One On One Oracle” “Chapter 3 Locking and concurrency” The author goes into the issues about locking and concurency in great details, and I understood that chapter. Not appropriately load balanced. Thin Driver Performance August 05, – Tom, Thanks Again, you are simply the best Press any key to continue.
|Date Added:||10 February 2012|
|File Size:||30.49 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
It’s the fastest driver and the most robust one.
Difference Between Thin and OCI drivers | Oracle Community
It appears that Weblogic has recently integrated the software to which you refer: This link describes more on Programming and comparison to ProC concepts. I have a regarding which JDBC client side driver to use: This contains some useful info: Now we found that in 10g thin is so much improved that oracle recommends using it. Your input on this is highly appreciated.
This means they can’t use the Names server to connect, which in turn makes manageability more difficult. Shouldn’t it be closer or the same as the PreparedStatement? Tom Kyte from Reston VA. This question is Whilst you are here, check out some content from the AskTom team: Tom, I have notified one of our development teams of your problem.
What do you recommend for a average OLTP system, is it still ‘old rule’ use oci as it’s native or is thin so much improved now?
I would figure my “Parse” and “Execute” counts to be the same as the PreparedStatement version. It only gets you part way there. I took the above so called “test” and modified it to meet what I believe would be a true test.
What does one conclude from this?
I borrowed a lot of information for my presentation from what I learned here and from your books. Email Required, but never shown. Back to OCI vs. I’ve modified the unix script to work with windows. I wish our DBAs would hear you out. Tom, Performance for thin vs. Suvasis OCI is just the protocol the driver talks.
Just Great March 07, – 3: This means all the Oracle Fusion Apps use the thin driver. We know Tom drives Hybrid: Press any key to continue. The following is the single user test environment, but it doe’nt matter as one should scale with multiple users not with single user.
Kyte January 01, – 4: Would OCI help in this case? Question and Answer Thanks for the question, Nick. I own a book named “Expert One On One Oracle” “Chapter 3 Locking and concurrency” The author goes into the issues about locking and concurency in great details, and I understood that chapter.
ORCL”, “scott”, “tiger” ; con. What other impact can it have wrt to deployment, performance, maintenance etc. I’ve also learned a few interesting things that I would like to share with our readers here.
It’s great when you provide simple tests to debunk misinformation.