RE: Jboss/Oracle/select 1 form dual

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_at_gmail.com] Sent: Thursday, May 07, 2009 4:51 PM
To: Pradeep Chetal
Cc: oracle-l_at_freelists.org
Subject: Re: Jboss/Oracle/select 1 form dual  

On Thu, May 7, 2009 at 10:52 AM, Pradeep Chetal <Pradeep.Chetal_at_mformation.com> 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

--
http://www.freelists.org/webpage/oracle-l