You can use the Oracle dbms_stats and export utilities to migrate schema statistics from your PROD instance to your TEST instance, so that your developers…
View More Export Import statistics with dbms_stats in Oracle
Tag: DBMS_STATS
Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS
DBMS_STATS package was introduced in Oracle 8i and used to gather Database,table,Schema,dictionary and fixed object statistic in Oracle database. Statistic of objects should be up…
View More Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS