• Online, Self-Paced
Course Description

General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database 11g Release 2, including elements such as Automatic Workload Repository (AWR) and database health checkers. DBAs must make sure that databases are open and available to users when they need it and that it is working without bottlenecks by gathering performance metrics. This course explores how to specify, review, and maintain audit information. It also discusses how to use Enterprise Manager to monitor performance, and how to use Automatic Memory Management (AMM) and the Memory Advisor to size the memory areas correctly, as well as how to troubleshoot invalid and unusable objects. This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).

Learning Objectives

Database Maintenance

  • manage Oracle optimizer statistics
  • manage Automatic Workload Repository statistics
  • use the Automatic Database Diagnostic Monitor and advisors
  • view and configure automated maintenance tasks
  • manage alerts

 

Performance Management

  • monitor and analyze the performance of the database
  • maintain the database by viewing information and implementing a given recommendation
  • manage database performance

 

Framework Connections