Need some help ? Call us:+352 20 30 10 60
Back

Oracle Database: Performance Management and Tuning - Live Virtual Classes

Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance components.

  • Use the Oracle tuning methodology
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
  • Use database advisors to proactively correct performance problems
  • Identify problem SQL statements 
  • Tune SQL performance problems
  • Monitor instance performance by using Enterprise Manager 
  • Tune instance components by primarily using instance parameters

  • Administrator
  • Database Administrator

You might also be interested in:

New

Oracle Database Security: Preventive Controls - Live Virtual Classes

In the Oracle Database Security: Preventive Controls course, students learn how they can
use Oracle Database Security products and technologies to meet the security, privacy and
compliance requirements of their organization. The current regulatory environment of
the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better
security at the database level. Students learn how to secure the access to their databases
and how to use the Oracle Database Security products and technologies that enhance
data access and confidentiality. The course provides suggested Oracle solutions for
common problems.

MySQL Performance Tuning - Live Virtual Classes

This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.

New

Oracle Database 12c R2: Clusterware Administration - Live Virtual Classes

This Oracle Database 12c: Clusterware Administration training will explore general cluster
concepts and Oracle Clusterware architecture. Work with expert Oracle University
instructors through interactive instruction and hands-on exercises to reinforce your
learning.In this course, you will be introduced to Oracle Database Exadata Cloud Service.