Oracle Database 12c: Performance Management and Tuning Ed 1/1Z0-417

Oracle Database 12c: Performance Management and Tuning Ed 1 Certification Training Course 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.

Oracle Database 12c: Performance Management and Tuning Ed 1 (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 3100
08 - 12 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

04 - 08 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3550
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Topic details are not available.
Module 2: Basic Tuning Diagnostics
  • Topic details are not available.
Module 3: Using Automatic Workload Repository
  • Topic details are not available.
Module 5: Using Metrics and Alerts
  • Topic details are not available.
Module 6: Using Baselines
  • Topic details are not available.
Module 7: Using AWR-Based Tools
  • Topic details are not available.
Module 9: Monitoring Applications
  • Topic details are not available.
Module 10: Identifying Problem SQL Statements
  • Topic details are not available.
Module 11: Influencing the Optimizer
  • Topic details are not available.
Module 12: Reducing the Cost of SQL Operations
  • Topic details are not available.
Module 13: Using SQL Performance Analyzer
  • Topic details are not available.
Module 14: SQL Performance Management
  • Topic details are not available.
Module 15: Using Database Replay
  • Topic details are not available.
Module 16: Tuning the Shared Pool
  • Topic details are not available.
Module 17: Tuning the Buffer Cache
  • Topic details are not available.
Module 18: Tuning PGA and Temporary Space
  • Topic details are not available.
Module 19: Automatic Memory
  • Topic details are not available.
Download Course Contents

Request More Information

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

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 12c Performance Management Tuning Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.