CHAPTER
7
Performance-Related New Features
When discussing “Oracle performance,” it can mean one of a dozen different things. Regardless of how you describe Oracle performance, it usually boils down to optimizing your storage, ensuring that statistics are up to date, and leveraging your SGA and PGA as a first-tier storage device.
In this chapter, I’ll first describe how index monitoring has been completely reinvented to provide a much higher level of granularity than previous incarnations of index monitoring. Next, I’ll explain how the Optimizer Statistics Advisor can force you to stay “up to date” on Oracle statistics best practices by incorporating ...
Get Oracle Database 12c Release 2 New Features now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
