Actually I am using dynatrace profiler and it tells me that out of 4000 calls to Oracle, min time is 4 ms, avg time is 10 msec, and max time is 3780 msec Since avg is so close to min, I am assuming there are very few outliers but want to understand why. -- Pradeep ________________________________ From: Jared Still [mailto:jkstill@xxxxxxxxx] Sent: Thursday, May 07, 2009 4:51 PM To: Pradeep Chetal Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Jboss/Oracle/select 1 form dual On Thu, May 7, 2009 at 10:52 AM, Pradeep Chetal <Pradeep.Chetal@xxxxxxxxxxxxxx> wrote: Folks, 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? How do you know it's the database? There's a fair bit of infrastructure involved there. Do you have a network admin involved so you can trace the SQLNet connections and see where they are going, and how long it takes? Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist 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