Re: Jboss/Oracle/select 1 form dual

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Pradeep.Chetal@xxxxxxxxxxxxxx
  • Date: Thu, 7 May 2009 13:50:41 -0700

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

Other related posts: