Re: 66,000.00 times slower, please your opinion

Do you have a lot of row migration/chainning as a result of that? Do you see more buffer gets? Check v$sysstat for 'table fetch continued row', is the count growing fast?

Richard Ji

On Thu, 17 Feb 2005 16:29:49 -0400, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> Thank you, is true; I'm verifying in execution is taking a full scan
> path. (different to the one was got through autorace) I'll check this
> situation, thank you I must be blind.
>
> On Thu, 17 Feb 2005 16:26:13 -0400, Juan Carlos Reyes Pacheco
> <juancarlosreyesp_at_gmail.com> wrote:
> > Yes, index and tables were analyzed, and i verifyed using autotrace,
> > indexes are being used.
> >
>
> --
> Oracle Certified Profesional 9i 10g
> Orace Certified Professional Developer 6i
>
> 8 years of experience in Oracle 7,8i,9i,10g and developer 6i
> --
> http://www.freelists.org/webpage/oracle-l
>

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