This content has been marked as final. Show 3 replies
user10745179 wrote:With V10+ Oracle, default behavior is that statistics are gathered once every 24 hours
My senior asked me to gather schema stats every day after importing the schema,
I have doubts about the gather schema stats
Why we gather schema stats, how we gather stats in oracle 10g, 11g?
Have a read of this information on [url http://www.ora00600.com/scripts/statistics/gathering_statistics.html]gathering stats in oracle and then have a read of a great article from Richard Foote about [url http://richardfoote.wordpress.com/2010/02/16/how-does-an-execution-plan-suddenly-change-when-the-statistics-remain-the-same-in-limbo/]execution plan changes when stats remain the same.
Gathering stats is one of those hotly debated topics. Some say you should, some say you shouldn't. You need to find what works for you because, ultimately, system performance, stability and plan stability are the ultimate goals. If you are using 11g you could look at SQL Plan Management.