Locking Stats To prevent statistics being overwritten, you can lock the stats at schema, table or partition level. EXEC DBMS_STATS.lock_schema_stats(‘SCOTT’); EXEC DBMS_STATS.lock_table_stats(‘SCOTT’, ‘EMP’); EXEC DBMS_STATS.lock_partition_stats(‘SCOTT’,…
View More How to Lock, Unlock, Transfer Statistics in oracle