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.
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.
Course Overview Hi everyone! My name is Tim Boles, and welcome to my course, OCP 12c Using Performance Enhancements in Oracle 12c Database. I'm a senior manager of database services at Hitachi Consulting. I've been working for over 19 years with Oracle Database technologies. When Oracle releases new versions of the database, it is important to get to know the new features. Learning about new performance enhancements in Oracle 12c will help you decide if your systems can take advantage of these new features, and it will help you prepare to upgrade your Oracle certification to the current version. In this course, we're going to introduce you to several new features that will bring a better performance from your Oracle 12c Database. We'll show you how to do more than monitor single SQL statements with real-time database operation monitoring. We'll take a look under the covers at how the optimizer is picking better explain plans on the fly. We'll see how to achieve the best resource utilization to the Resource Manager in switching to the multi-threaded architecture. Finally, we'll check out how to perform DDL while users are still accessing the objects being changed. By the end of this course, you'll know the benefits and some of the limitations of the new performance enhancements of Oracle 12c. These will help you prepare to take the OCP exam 1Z0-060. From here, you should feel comfortable diving into other Oracle OCP 12c courses that I've created on Pluralsight. I hope you'll join me on this journey to learn the new performance enhancements of Oracle with OCP 12c using performance enhancements in the Oracle 12c course at Pluralsight.