Online Automatic Workload eLearning

Oracle Database 11g R2 Managing Database Memory Performance Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...

Oracle Database 11g Using AWR Defining Problems ... Database 11g: Using AWR & Defining Problems Oracle Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual AWR  more...

Oracle Database 11g Metrics Alerts Baselines AWR Tools Services ...performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This course demonstrates how to create static and repeating baselines, compute baseline statistics, define alert thresholds, and generate ADDM and ASH reports. In Oracle Database 11g you can  more...

Oracle Database 11g Execution Plans and Star Transformations Oracle Database 11g: Execution Plans and Star Transformations Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements ...1g 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  more...

Oracle Database 11g R2 Managing Database Maintenance Performance ...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  more...

Oracle Database 10g New Features for Administrators Part 1 ... provided by Oracle Database 10g. Identify features of Automatic Workload Repository (AWR) in statistics collection. Identify features of a policy framework. Identify features of the initialization parameters in Oracle Database 10g. Unit 3: Loading and Unloading Data Identify features of transportable tablespaces (TTS). Identify functional architecture of Data Pump.  more...

Oracle Database 10g New Features for Administrators Part 2 ... Shared Memory Management (ASMM). Identify features of Automatic Workload Repository (AWR). Identify features of Automatic Workload Repository (AWR) snapshots. Identify options for configuring Automatic Workload Repository (AWR). Identify guidelines for gathering optimizer statistics. Identify features of Automatic SQL Tuning. Identify features of SQL Tuning Advisor.  more...