Just a WAG, but do any of your objects have a huge number of extents?
Dan.
> -----Original Message-----
> From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 4:23 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Win2000/8.1.7.3.0/SQL
>
>
> John:
>
> > Does that particular Db have it's SYS schema ANALYZED? This
> should return no
> > rows - if it does, then you can drop the stats for SYS and
> run this query
> > again.
>
> Nope. Checked that already, but I checked it again. Any other
> suggestions?
>
> Thanks,
> Mike
