Re: SQL Traces' Comparison

External factors?

disk getting hammered during the second trace?

Jack


On 15/08/2008, Rakesh Tikku <rakesh.tikku@xxxxxxxxx> wrote:
>
> How about parameters/bind variable values passed to the program/sql?
> Where they identical in both cases ?
>
> Rakesh Tikku
> Managing Principal
> dbPerf Inc.
>
> On Thu, Aug 14, 2008 at 10:10 AM, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
> wrote:
> > Folks
> >
> >
> >
> > For the same SQL with the same execution Path on the same Database, what
> is
> > the possible cause for High Elapsed Time ub Case 2 (below)?
> >
> > NOTE - Table sizes having grown Slightly (by a few GB) in Case 2
> >
> >
> >
> > Will provide any detail needed
> >
> >
> >
> > Cheers & Thanks
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
J.A. van Zanen

Other related posts: