From users-return-216772-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org Thu Sep 09 09:02:21 2010 Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 49614 invoked from network); 9 Sep 2010 09:02:21 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 9 Sep 2010 09:02:21 -0000 Received: (qmail 92311 invoked by uid 500); 9 Sep 2010 09:02:18 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 92030 invoked by uid 500); 9 Sep 2010 09:02:15 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 92021 invoked by uid 99); 9 Sep 2010 09:02:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Sep 2010 09:02:15 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.9] (HELO minotaur.apache.org) (140.211.11.9) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 09 Sep 2010 09:02:14 +0000 Received: (qmail 49547 invoked by uid 99); 9 Sep 2010 09:01:54 -0000 Received: from localhost.apache.org (HELO [192.168.23.9]) (127.0.0.1) (smtp-auth username markt, mechanism plain) by minotaur.apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Sep 2010 09:01:54 +0000 Message-ID: <4C88A279.4080201@apache.org> Date: Thu, 09 Sep 2010 10:01:45 +0100 From: Mark Thomas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-GB; rv:1.9.2.9) Gecko/20100825 Thunderbird/3.1.3 MIME-Version: 1.0 To: Tomcat Users List Subject: Re: pool error timeout waiting for idle object References: In-Reply-To: X-Enigmail-Version: 1.1.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 09/09/2010 07:57, sasidhar prabhakar wrote: > My application sometimes responding very slow. > When I observed the logs, it is showing these lines > > Cannot get a connection, pool error Timeout waiting for idle object. > The maximum connections on oracle I set 150. > maxActive="200" That doesn't look right. There are lots of things that could be going on here and you have provided very little in the way of information. Questions it would be helpful to have the answers to include: - Tomcat version - Oracle version - Oracle JDBC driver type and version - Number of connections from Tomcat reported by Oracle when this happens - What does a thread dump show those connections are doing Mark --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org