Monitoring and Tuning Database Performance

May 2019 with Ben Finkel

  • Entry
  • 7 videos
  • 41 mins
Join Ben Finkel as he teaches you how to monitor and tune the performance of your Oracle database.

Learn how to monitor your database performance with the Automatic Workload Repository (AWR), Database Enterprise Manager, and the Automatic Database Diagnostic Monitor (ADDM); how to upgrade an Oracle 10 or 11 database to 12c with the Database Upgrade Assistant (DBUA); and how to manually upgrade your database. Gain an understanding of the SQL tuning process, memory management, Oracle maintenance windows, and the three pre-defined maintenance tasks: the SQL Tuning Advisor, the automatic optimizer statistic collection, and the auto space advisor.

This is the ninth of an eleven-part series that will prepare you for Oracle's 1Z0-072 exam, one of two exams that must be passed to receive the Oracle Database 12c R2 Administration Certified Associate certification.

Recommended Experience
  • None
Recommended Equipment
  • None
Related Certifications
  • Oracle Database 12c R2 Administration Certified Associate
Related Job Functions
  • Data analyst
  • Database administrator
  • Database developer
  • Database designer
Ben Finkel has been a CBT Nuggets trainer since 2014. His areas of expertise include Google Developer Expert, Google Certified Trainer, Microsoft ASP.NET (WebForms and MVC), Data Analysis and Design, Relational Database Architecture, MS SQL Server, Microsoft C#.NET, Javascript, jQuery, Microsoft Visual Basic .NET & 6.0, .NET Reporting Services, MS Access, and Python.
Get started
Ben Finkel
Ben Finkel

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Accountability Coaching

Define your goals and stick to a training plan with help from our coaches.

Learn this skill and so much more!

Get started

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

Read Reviews
Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2023 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522