Skill
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.
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
- None
- Oracle Database 12c R2 Administration Certified Associate
- Data analyst
- Database administrator
- Database developer
- Database designer
Trainer