OCP 12c Enhancements for the DBA

Oracle is the most widely used database in the world. This course will introduce the new 12c features for monitoring the database and the ones that make administration easier for the DBA.
Course info
Level
Advanced
Updated
Dec 27, 2017
Duration
2h 15m
Table of contents
Description
Course info
Level
Advanced
Updated
Dec 27, 2017
Duration
2h 15m
Description

With each release of Oracle there comes new features and enhancements. In this course, OCP 12c Enhancements for the Database Administrator, you'll learn the new monitoring and administration features of Oracle 12c database. First, you'll discover how to perform real-time monitoring and diagnosis utilizing real-time ADDM, the ASH Analytics page, and the Emergency Monitoring tool. Then, you'll explore of the new data load capabilities of Oracle utilities, like Oracle Data Pump, external tables, and SQL*Loader. Finally, you'll learn about the new enhancements that make it easier to perform administration tasks such as monitoring DDL statements and performing maintenance on partitions. When you're finished with this course, you'll be one step closer to having all the skills and knowledge to pass the OCP 12c Upgrade Certification exam 1z0-060. Software required: Oracle 12.1.0.x database.

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
Effective Reporting with Power BI
Intermediate
2h 16m
Feb 12, 2019
More courses by Tim Boles
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Tim Boles. I'm a senior manager at Hitachi Consulting. I'm excited to be sharing my experience from nearly 18 years of working with Oracle database technologies. Welcome to my course, OCP 12c Enhancements for the DBA. This is another course in a series of courses to help the viewer prepare to take the OCP 12c Upgrade Certification exam. With each new release of Oracle there are new features and enhancements. In this course, we're going to focus on the ones that will be of particular interest to the database administrator. We're going to cover the ability to quickly determine database problems through enhancements and emergency monitoring, the Automatic Database Diagnostic Monitor, and the ASH Analytics page. There are new enhancements in the tools that unload and load data into the database. There are also new technologies in partition that increase their versatility and reduce the amount of time and effort for performing partition maintenance. By the end of this course you'll be familiar with the enhancements in Oracle 12c that will help you quickly diagnosis performance problems and changes in the system. You'll also have a good grasp on the new capabilities and its cleaner syntax of the Oracle utilities that load and unload data from the database. I hope you'll join me on this journey to learn some of the new features that will make the DBA's life a little easier, in the OCP 12c Enhancements for the DBA course, at Pluralsight.