Re: Jboss/Oracle/select 1 form dual

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Fri, 8 May 2009 06:30:00 +0200
Message-ID: <8580d4110905072130x5423507dhb25873d7d3ea24c9_at_mail.gmail.com>

How about instrumenting the code to set module, action, and client_info (or whatever combination you need) so that you then can trace just this statement. It will of course increase the cost of this statememnt slightly, but you can then do a database wide trace without having to incur the overhead for tracing all statements.

Can you explain more what your tracetool actually tells you? DOes it tell you it was actually processing in the DB or that the program was waiting for a SQL call to return. It may seem like a small difference, but it is actually very important to understand that difference.

Mathias

On Thu, May 7, 2009 at 10:52 PM, Pradeep Chetal < Pradeep.Chetal_at_mformation.com> wrote:

>
>
> 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

Received on Thu May 07 2009 - 23:30:00 CDT