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.

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