RE: SHOULD WE ANALYZE 9.2 SYS tables?
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 Jul 2004 09:49:30 -0700 (PDT)
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@xxxxxxx> 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@xxxxxxxxxxx]
> Sent: Friday, July 30, 2004 8:21 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
> Sent: Thursday, July 29, 2004 1:36 PM
> To: 'oracle-l@xxxxxxxxxxxxx'
> 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@xxxxxxxxxx]=3D20
> Sent: Thursday, July 29, 2004 2:23 PM
> To: 'oracle-l@xxxxxxxxxxxxx'
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
