RE: SHOULD WE ANALYZE 9.2 SYS tables?

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Fri, 30 Jul 2004 09:49:30 -0700 (PDT)
Message-ID: <20040730164930.85256.qmail@web50110.mail.yahoo.com>

The 9205 patch set release note mentions following:

" Upgrade and SYS Schema

This is a generic issue applicable to the upgrade mode, for example, alter database open migrate. During an upgrade from release 9.2.0.1 to release 9.2.0.2, release 9.2.0.3, release 9.2.0.4 or release 9.2.0.5, the catpatch.sql script can take a long time if there are statistics for the SYS schema. The user should delete the statistics on all the objects in the SYS schema, and then re-collect the statistics after normal database open, if necessary.

To drop and re-create the statistics, run the following commands:

dbms_stats.delete_schema_stats('SYS');
dbms_stats.gather_schema_stats('SYS'); "

so.. is 9i really ready for stats on SYS schema tables/clusters/indexes?? I surely don't gather stats on SYS schema, yet.

Regards,

Kirti
- "Tortorelli, Mary Jo" <tortorelli_at_ppg.com> wrote:

> I second Allan's comment. I just did it as part of upgrading an 11i =
> Apps database from 8.1.7.4 to 9.2.0.5. It is step 18 in the =
> interoperability notes (#216550.1).
>
> -----Original Message-----
> From: Nelson, Allan [mailto:anelson_at_miswaco.com]
> Sent: Friday, July 30, 2004 8:21 AM
> To: oracle-l_at_freelists.org
> Subject: RE: SHOULD WE ANALYZE 9.2 SYS tables?
>
>
> As part of the upgrade to 9.2 from 8.1.7 in an Oracle Financials
> environement it is required.
>
> Allan
>
> -----Original Message-----
> =3D46rom: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
> Sent: Thursday, July 29, 2004 1:36 PM
> To: 'oracle-l_at_freelists.org'
> Subject: RE: SHOULD WE ANALYZE 9.2 SYS tables=3D3F
>
>
> Larry,
>
> We are not analyzing SYS tables, nor do we plan to. We have both
> migrated
> databases to 9.2 and created them brand new. In either case, the
> migration
> documentation does not say anything about anaylzing the sys tables. And
> the
> sys tables in the new 9.2 database do not come already analyzed.
>
> So I would guess that they are not supposed to be analyzed.
>
> Anybody else=3D3F
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> =3D46rom: Wolfson Larry - lwolfs =
> [mailto:lawrence.wolfson_at_acxiom.com]=3D20
> Sent: Thursday, July 29, 2004 2:23 PM
> To: 'oracle-l_at_freelists.org'
> Subject: SHOULD WE ANALYZE 9.2 SYS tables=3D3F
>
>
> I had a question about a problem with 9.2 V$ views where a RULE hint
> helped
> V$LOCK tremendously.
>
> Someone suggested Analyzing the SYS tables. IS everyone doing that now
> or
> is there considerable reticence=3D3F I didn't get a much current
> information
> when I searched the FAQ or Google
>
> Has anyone experienced a downside=3D3F
>
> Is anyone doing some of the tables but not all=3D3F
>
> Thanks
> Larry Wolfson
>
>
>
>

Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 30 2004 - 11:46:43 CDT