Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and improved query and DML performance. Application performance in Oracle Database 11g Release 2 is also improved by the use of adaptive cursor sharing, which allows for intelligent cursor sharing and the use of invisible indexes. It provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section function result caching mechanism, which provides a language-supported and system-managed means for storing the results of PL/SQL functions in the SGA, so that they are available to all the application sessions that are running. This course identifies the new online redefinition enhancements for tables, invisible indexes, adaptive cursor sharing, and using SQL Query Result, Client Query, and PL/SQL Function Caches.
This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
Learning Objectives
Application Performance Enhancements
- identify online redefinition enhancements
- recognize the features of invisible indexes
- identify the features of Adaptive Cursor Sharing
- use the SQL query result cache
- use the client-side query cache
- identify the features of the PL/SQL function cache
- improve application performance