Re: Upgrade from 8.1.6 to 8.1.7 really slow

"Mark D Powell" <mark.powell_at_eds.com> wrote in message news:178d2795.0205130540.108a493c_at_posting.google.com...
> And
> how were the statistics created? I have not personally verified this
> but I have read that the statistics created by dbms_stats cannot be
> replaced by an analyze, but either have to be deleted first or
> replaced by a new run of dbms_stats.
>
> HTH -- Mark D Powell --

Not true. (or not universally true)

SQL*Plus: Release 9.0.1.0.1 - Production on Mon May 13 16:17:59 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Release 8.1.7.3.0 - Production
JServer Release 8.1.7.3.0 - Production

SQL> desc rm_agltransact;
ERROR:
ORA-04043: object rm_agltransact does not exist

SQL> select table_name from user_tables
  2 where table_name like 'RM%';

TABLE_NAME

RM_ACRTRANS
RM_ATSINVTRANS
RM_ATSINVTRANS2

SQL> begin
  2 dbms_stats.gather_table_stats('AGRPROD','RM_ATSINVTRANS');   3 END;
  4 /

PL/SQL procedure successfully completed.

SQL> ANALYSE TABLE RM_ATSINVTRANS ESTIMATE STATISTICS; SP2-0734: unknown command beginning "ANALYSE TA..." - rest of line ignored. SQL> ANALYZE TABLE RM_ATSINVTRANS ESTIMATE STATISTICS; Table analyzed.

SQL>

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************