Get help WhatsApp
 

Oracle DBA - Level 5

Oracle DBA - Level 5

Oracle Database Administration – Superior level for configuration, securing, maintaining and protecting databases

 

Using General Overall Database Enhancements

  • Install Oracle Database software
  • Create, Delete and Configure Databases using DBCA
  • Creating CDBs and Regular PDBs
  • Use Miscellaneous 19c New Features

Using Availability Enhancements

  • Use an RMAN recovery catalog
  • Use Flashback Database

Monitoring and Tuning Database Performance

  • Managing Memory Components
  • Understanding The Automatic Workload Repository (AWR)
  • Understanding The Advisory Framework
  • Monitoring Wait Events, Sessions, and Services
  • Managing Metric Thresholds and Alerts
  • Understanding and Using The Performance Tuning Methodology
  • Performing Performance Planning
  • Understanding The Automatic Database Diagnostic Monitor (ADDM)

Tuning SQL Statements

  • Understanding The Oracle Optimizer
  • Using The SQL Tuning Advisor
  • Managing Optimizer Statistics
  • Using The SQL Access Advisor
  • Understanding The SQL Tuning Process

Course Enquiry