Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SHOULD WE ANALYZE 9.2 SYS tables?
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,
> 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
>
>
>
>
-- 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
![]() |
![]() |