By default there are stats generation procedures running automatically in Oracle11g. In my experience, if you have manual stats running, try to phase out the manual stats in favor of Oracle automation because otherwise you might find yourself going backwards and forwards with stats tweaks for years – because stats are generic and change with …
Continue reading “Checking Oracle Automated Statistics Generation”