Re: Jboss/Oracle/select 1 form dual

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 7 May 2009 13:50:41 -0700
Message-ID: <bf46380905071350p65bfbe8fmbd53fc0ff5fb1a7d_at_mail.gmail.com>

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

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

Received on Thu May 07 2009 - 15:50:41 CDT