Where do i start for troubleshooting this issue

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 14 Aug 2009 06:40:26 +0000 (GMT)
Message-ID: <734113.53193.qm_at_web23703.mail.ird.yahoo.com>


I have a database where a JDBC app using connection pool makes a connection.Currently there are 30 sessions inside the database and most fo them being inactive.

The max sessions parameter is defined as 50.

When i do a tnsping to the service name in a shell script the listener responds in like 3500 secs ocassionally.

Where do i start troubleshooting this issue ?

Received on Fri Aug 14 2009 - 01:40:26 CDT

Original text of this message