How to check Stale statistics in Oracle Database
Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: The parameter setting required to Track the table …
How to check Stale statistics in Oracle Database Read More »