RE: PRODUCTION JDBC THIN and SQLPLUS NET8 Connection Behaviour

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_at_gmail.com] Sent: Monday, January 09, 2006 5:51 PM
To: Nagarajan.Subbiah_at_aetn.com
Cc: Oracle-L_at_freelists.org
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 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 . 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 Received on Tue Jan 10 2006 - 00:28:49 CST