Recently a customer raised a question whether there are differences between the Automatic Statistics Gathering job and a manual creation of stats via the GATHER_SCHEMA_STATS procedure.
The results in performance were quite interesting. Performance after an upgrade from Oracle Database 126.96.36.199 to Oracle Database 188.8.131.52 was not good when the automatic stats job got used. But performance changed significantly to the better when schema stats were created with the downside of taking more resources during the gathering.
Is the Automatic Stats Gathering job enabled?
That question can be answered quite easily. There’s a very good MOS Note:1233203.1 – FAQ: Automatic …Continue reading...