OCP 12c Using Performance Enhancements in Oracle 12c

Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Course Overview- 1m 53s
—Course Overview 1m 53sReal-time Database Operation Monitoring- 17m 16s
—Introduction 1m 39s
—What Is Real-time Database Operations Monitoring? 2m 0s
—Architecture of Database Operation Monitoring 2m 53s
—Creating, Monitoring, and Reporting Database Operations 3m 13s
—Demo: Creating, Reviewing, and Reporting 6m 35s
—Summary 0m 53sSQL Tuning - Using Adaptive Execution Plans- 22m 4sSQL Tuning - Adaptive Statistics- 12m 56sSQL Tuning - Adaptive SQL Plan Management (SPM)- 12m 29sResource Manager in the Multitenant Architecture- 17m 47sMulti-process Multi-threaded Architecture and Flash Cache- 13m 23sIndex and Table Enhancements- 11m 39sOnline Operation Enhancements- 12m 32sWrapping up Oracle 12c Performance Enhancements- 7m 29s