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.