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: Parameter setting required to Track the table changes […]
Techgoeasy
Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
