Oracle Database 11g Release 2: Managing Database Maintenance and Performance

Overview/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).

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g Release 2: Managing Database Maintenance and Performance

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

monitor and analyze the performance of the database

maintain the database by viewing information and implementing a given recommendation

manage database performance