Actually I do everything you say:

1. I read whole upgrade guide twice.

2. run utlu102i.sql on each database

I just don't understand why 10Gr2 need collect
statistics on "sys", but 9ir2 don't need.




--- Paul Drake <bdbafh@(protected):

> On 6/15/06, dba1 mcc <mccdba1@(protected):
> >
> > I am doing ORACLE 10Gr2 migration test. I found
> 10Gr2
> > migration guide say We need collect 'sys" and
> "system"
> > statictics before upgrade.
> >
> > I remember clearly on ORACLE 9ir2 document it
> suggest
> > NOT collect statistics on "sys" and "system". If
> we
> > collect "sys" or "system" statistics, it will
> cause
> > performance.
> >
> > My question is why ORACLE 10Gr2 does NOT have
> perform
> > issue if we collect statistics on "sys" or
> "system"?
> >
> >
> > Thanks.
> >
> >
> Congrats on the following points:
>
> 1. testing.
> 2. reading the upgrade guide 10g R2 B14238-01.
>
>
> Did you also run the script utlu102i.sql from a 10.1
> home?
> (its located in the new 10.2 home, under
> ?/rdbms/admin.
>
> Perhaps having the report print out while running
> from _your_ database will
> be more convincing than in .pdf form.
>
> hth.
>
> Paul
>
>
>
> --
> #/etc/init.d/init.cssd stop
> If you find yourself using the word "telnet"
> somewhere, be it in an email or
> a conversation, please stop and say "I'm sorry, I
> meant to use ssh instead."
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l