Query for Upgrade Statistics Tables Created by the DBMS_STATS Package
Hi Experts
This is additional post for thread in "Discussion of Note:837570.1 (Complete Checklist for Manual Upgrades to 11gR2)" in DB Install comunity.
User has below query which looks to be more suitable for DB performance community
Step 32
Upgrade Statistics Tables Created by the DBMS_STATS Package.
If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by executing the following procedure:
in the first place how do I know which tables are create by DBMS_STATS.CREATE_STAT_TABLE.
have check 10gr2 http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_stats.htm#sthref6598
This is additional post for thread in "Discussion of Note:837570.1 (Complete Checklist for Manual Upgrades to 11gR2)" in DB Install comunity.
User has below query which looks to be more suitable for DB performance community
Step 32
Upgrade Statistics Tables Created by the DBMS_STATS Package.
If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by executing the following procedure:
in the first place how do I know which tables are create by DBMS_STATS.CREATE_STAT_TABLE.
have check 10gr2 http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_stats.htm#sthref6598
0