Online Awr 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 ...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 reports as well as  more...

Oracle Database 11g Metrics Alerts Baselines AWR Tools Services ...AWR Tools & Services Oracle Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the 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  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 Managing Database Maintenance Performance ...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  more...

Oracle Database 10g New Features for Administrators Part 1 ...g. 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. Identify features of the Data  more...

Oracle Database 10g New Features for Administrators Part 2 ...). 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. Audience: The target course  more...