RE: Jboss/Oracle/select 1 form dual
- From: "Pradeep Chetal" <Pradeep.Chetal@xxxxxxxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Thu, 7 May 2009 16:52:46 -0400
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
Other related posts:
