Overview
This course is planned for Database Administrators. After completing this course, students will be able to learn about the performance analysis and tuning tasks on Oracle 12c database. Students will also learn tuning and diagnosis of SQL-related performance. This course is best suited for Data Warehouse Administrators and Database Administrators.
This course prepares you for Exam 1Z0-417. Download Course Contents
Course Prerequisites
- Oracle Database 12c: Administration Workshop
Upon Completion of this Course, you will accomplish following:-
- Comprehend how to tune and diagnose common Instance related performance issues
- Comprehend how to tune and diagnose common SQL related performance issues
- Comprehend how to view Histograms
- Comprehend Server-Generated Alerts
- Comprehend benefits of Metrics
- Comprehend how to view Metric History Information
- Comprehend how to employ methodology of Database tuning
- Comprehend how to employ database advisors to practically tune an Database Instance
- Comprehend how to employ Enterprise Manager performance-related pages to scrutinize an database
- Comprehend how to employ Automatic Workload Repository
- Comprehend how to set Thresholds