I’ve been having a play around with the enhancements to the statistics collection in 12c. I’ve put together this top-level post with links to all my other articles on this subject.
Here are the new articles it links to.
- Session-Private Statistics for Global Temporary Tables in Oracle Database 12c Release 1 (12.1)
- Concurrent Statistics Collection in Oracle Database 12c Release 1 (12.1)
- Online Statistics Gathering for Bulk Loads in Oracle Database 12c Release 1 (12.1)
- Histogram Enhancements in Oracle Database 12c Release 1 (12.1)
It also links to some of the stuff I put out previously for the Adaptive Query Optimization functionality, as that is statistics related.
- Dynamic Statistics in Oracle Database 12c Release 1 (12.1)
- SQL Plan Directives in Oracle Database 12c Release 1 (12.1)
- Automatic Reoptimization in Oracle Database 12c Release 1 (12.1) – Statistics Feedback
In a totally unrelated incident, I wrote this thing about the new READ object privilege, but forgot to mention it on the blog.
The journey continues…
Cheers
Tim…