OCP 12c Using Performance Enhancements in Oracle 12c

You can upgrade your current OCP certification to 12c with a single test. This course dives into the new features of performance enhancements in Oracle 12c, which you need to know to pass the test.
Course info
Level
Advanced
Updated
Jun 23, 2017
Duration
2h 9m
Table of contents
Course Overview
Real-time Database Operation Monitoring
SQL Tuning - Using Adaptive Execution Plans
SQL Tuning - Adaptive Statistics
SQL Tuning - Adaptive SQL Plan Management (SPM)
Resource Manager in the Multitenant Architecture
Multi-process Multi-threaded Architecture and Flash Cache
Index and Table Enhancements
Online Operation Enhancements
Wrapping up Oracle 12c Performance Enhancements
Description
Course info
Level
Advanced
Updated
Jun 23, 2017
Duration
2h 9m
Description

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.

About the author
About the author

As a teenager, Tim found a love for teaching, learning, writing, and computers. He believes that everyone should be a lifelong learner. Tim has been teaching for nearly 21 years, either full or part-time. Tim is an Oracle Database Administrator with over 17 years of experience. He works out of Pittsburgh PA and lives in West Virginia with his wife and kids.

More from the author
More courses by Tim Boles