CHAPTER 4Performance Management
Oracle Database 11g adds several weapons to the arsenal of the DBA looking to improve performance and scalability. Automatic native compilation of PL/SQL code means you'll now get much faster PL/SQL performance automatically when you upgrade applications to the new release. The new server cache feature dramatically increases performance for SQL queries as well as for PL/SQL functions by retrieving results straight from the cache instead of reexecuting code. There is also a new client-side result caching feature for OCI applications.
The new SQL Plan Management (SPM) feature helps you stabilize SQL execution plans to prevent a performance regression due to unexpected changes in the execution plans of SQL statements. ...
Get Oracle Database 11g: New Features for DBAs and Developers 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.
