RE: PRODUCTION JDBC THIN and SQLPLUS NET8 Connection Behaviour
- From: "Subbiah, Nagarajan" <Nagarajan.Subbiah@xxxxxxxx>
- To: 'Sriram Kumar' <k.sriramkumar@xxxxxxxxx>
- Date: Mon, 9 Jan 2006 18:28:49 -0500
Thanks, Sriram.
I tested the sample JdbcTest program with java 1.2.2 and 8i thin driver
classes12.zip and it was instantaneous where as j2se5 and ojdbc14.jar
environment is trying to lookup for the DNS entry eventhough we used the IP
address which was timing out and get the connection after 40- 60 seconds.
The 'truss' command in solaris helped to figure out the difference.
We have resolved the issue. It was due to the DNS error.
-Raja
Ph: 212-210-1461
-----Original Message-----
From: Sriram Kumar [mailto:k.sriramkumar@xxxxxxxxx]
Sent: Monday, January 09, 2006 5:51 PM
To: Nagarajan.Subbiah@xxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: PRODUCTION JDBC THIN and SQLPLUS NET8 Connection Behaviour
Hi,
May be you can check the following
1. Check if MTS is enabled. MTS+ Connection pooling is not a good idea.
Implement EIther MTS or connection pooling but not both. There have been
instances when the response time has been pathetic when we implement both.
2. Check if your connection pooling prespawns certain number of connections
before it returns a connection to the application. Not sure on this but IIRC
certain application servers when asked for a DB connection would prespawn
certain number of connections thinking that these connections would be used
later.
3. Check if you can use OCI driver and check the performance. You can write
a small stub to test OCI vs Thin and check out the performance.
4. Perform a Sqlnet tracing for a brief period and check the logs. Need be
raise a TAR
Hope it helps
Best Regards
Sriram Kumar
On 1/9/06, Subbiah, Nagarajan <Nagarajan.Subbiah@xxxxxxxx
<mailto:Nagarajan.Subbiah@xxxxxxxx> > wrote:
Hi List,
We are having a production issue. The production application server is
establishing the connection pool connection using Java and the JDBC Oracle
Thin Driver 9.2.0.5 <http://9.2.0.5/> . The connection pool connection takes
about 40 seconds to establish a connection and once the connection is
established then it serves the subsequent request very fast. The SQLPLUS
connection is very fast from the appliction server and it connects
instantaneously. Does any one have any idea what might causing this.
Thanks,
Raja
Other related posts:
