Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource Manager the DBA has the ability to optimize resource allocation among many different database sessions to prevent excessive overhead. This course identifies how to automatically tune SQL statements using Automatic SQL Tuning, use Automatic Workload Repository baselines to gather performance metrics, control maintenance tasks, determine I/O metrics using I/O Calibration tool, and use Resource Manager.
This course is one of a series in the Skillsoft learning path that covers objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.
- setup and manage Automatic SQL Tuning
- identify the features of AWR baselines
- control automated maintenance tasks
- determine and gather I/O metrics
- identify the Resource Manager database and server consolidation features
- identify the features of instance caging
- creating AWR baselines
- control an AutoTask job
- calibrate I/O resources