DBMS_STATS.GATHER_SCHEMA_STATS Failing in 10.2.0.3

After a migration of 9.2.0.8 database to 10.2.0.3 major performance problem(slowness) was observed.When the database was on 9i, stats were gathered weekly using dbms_stats.gather_schema_stats package for the application specific schemas. exec dbms_stats.gather_schema_stats(ownname =>'ABC',cascade => true,degree =>3); The above was scheduled in the crontab to be run every saturday.After the database was migrated successfully, the crontab … Continue reading DBMS_STATS.GATHER_SCHEMA_STATS Failing in 10.2.0.3