Re: 66,000.00 times slower, please your opinion

  • From: Richard Ji <richard.c.ji@xxxxxxxxx>
  • To: juancarlosreyesp@xxxxxxxxx
  • Date: Thu, 17 Feb 2005 17:55:32 -0500

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@xxxxxxxxx> 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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2005