Monitoring and Tuning Database Performance
May 2019 with Ben Finkel
- 7 videos
- 41 mins
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.
- Oracle Database 12c R2 Administration Certified Associate
- Data analyst
- Database administrator
- Database developer
- Database designer