ORACLE 10gr2 collect statistics on sys and system?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 15 Jun 2006 11:52:30 -0700 (PDT)
Message-ID: <20060615185230.65676.qmail@web60825.mail.yahoo.com>

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.

---

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

Received on Thu Jun 15 2006 - 13:52:30 CDT