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>



Hi


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 ?


regards
Hrishy


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 14 2009 - 01:40:26 CDT

Original text of this message