Overview/Description
Identify how to to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11g's intelligent infrastructure enhancements.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g
Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
recognize the scope of Oracle Database 11g's AWR Baselines feature, which includes baseline template creation options and baseline views.
recognize the steps for creating an AWR Baseline and using it to define alert thresholds.
recognize the benefits of the Automatic Maintenance Tasks feature for statistics collection, segment advisor, and Automatic SQL Tuning, and identify how to control such tasks.
recognize the steps for calibrating I/O resources in Oracle Database 11g.
recognize how to manage resources and streamline schedules using the Resource Manager and lightweight jobs.
identify the steps for creating and running lightweight scheduler jobs.