Each version of Oracle comes with new features. You have to know these features to test for your OCP certification. In this course, OCP 12C Using Performance Enhancements in Oracle 12c, you’ll learn foundational knowledge related to performance enhancements in the 12c version of the database. First, you’ll explore how to go beyond monitoring single SQL statements with the use of database operation sets. Next, you’ll learn about Oracle’s ability to adapt SQL plans on the fly responding to real-time statistics. Additionally, you’ll discover how to better manage Oracle’s utilization of server resources through implementation of the multi-threaded environment and the resource manager. Finally, you’ll learn how to use the new tools available to the developer and database administrator, to perform system changes while users still access the database objects being changed. When you’re finished with this course, you’ll have the skills and knowledge of the performance enhancements that are part of the Oracle 12c database, and be closer to having all the knowledge you need for the OCP 12c upgrade test.
Author Name: Tim Boles
Author Description:
Tim Boles is an Oracle Database Administrator with over 18 years experience. He has worked with every version of Oracle since version 7. His professional specialties include Operations and Management in high value systems, Oracle database backup & recovery and providing database managed services to clients.

Table of Contents

• Course Overview
  1min
• Real-time Database Operation Monitoring
  17mins
• SQL Tuning – Using Adaptive Execution Plans
  22mins
• SQL Tuning – Adaptive Statistics
  12mins
• SQL Tuning – Adaptive SQL Plan Management (SPM)
  12mins
• Resource Manager in the Multitenant Architecture
  17mins
• Multi-process Multi-threaded Architecture and Flash Cache
  13mins
• Index and Table Enhancements
  11mins
• Online Operation Enhancements
  12mins
• Wrapping up Oracle 12c Performance Enhancements
  7mins