Saturday, May 16, 2015

Weekend Learning: 12c: Automatic Dynamic Statistics

Did you know that Oracle Database 12.1 introduces some new ways to sample dynamic statistics for query optimization?  You are probably familiar with setting this in the 11gR2 world but 12c allows us to set this at a more granular level so it can be done at a statement level and you can find all the details at "Automatic Dynamic Statistics" on My Oracle Support from note ID 2002108.1 to see what has to be enabled for this to work.

No comments:

Post a Comment