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