Re: Jboss/Oracle/select 1 form dual
Date: Thu, 7 May 2009 13:50:41 -0700
On Thu, May 7, 2009 at 10:52 AM, Pradeep Chetal < Pradeep.Chetal_at_mformation.com> wrote:
> 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?
Certifiable Oracle DBA and Part Time Perl Evangelist