Jboss/Oracle/select 1 form dual

From: Pradeep Chetal <Pradeep.Chetal_at_mformation.com>
Date: Thu, 7 May 2009 13:52:18 -0400
Message-ID: <B1C751058F4E7C41BD50130B0750DD93015E0222_at_mfusemail01.mformation.com>

Folks,

We have a Jboss-4.0.2 based application and it is set to do 'select 1 from dual' for connection validation purposes.

Most of the time the query returns in less than 10 msec but we have seen few cases where it shows that it took almost 3500 msec.

How can I find out - why it takes more than 3 seconds for these few cases? What is going on in the DB that it takes that long? What will enable me to find that?

We are heavy users of AQ.

This system is running on Solaris X86.

Thanks,

Pradeep

Pradeep Chetal
Sr. Director - Infrastructure Architecture

Mformation Technologies Inc.
Switchboard: +1 732 692 6200

Visit WWW.MFORMATION.COM and see how the MFORMATION SERVICE MANAGER can help you to transform your business

Please consider the environment before printing
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 07 2009 - 12:52:18 CDT

This message: [ Message body ]
Next message: Rumpi Gravenstein: "Re: How to determine sessions with invalid package states"
Previous message: Daniel Fink: "Re: Interpreting a direct path read wait"
In reply to: Tanel Poder: "RE: Long Parse Time"
Next in thread: Jared Still: "Re: Jboss/Oracle/select 1 form dual"
Reply: Jared Still: "Re: Jboss/Oracle/select 1 form dual"
Maybe reply: Martin Busik: "Re: Jboss/Oracle/select 1 form dual"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message