Online Autotrace eLearning

Oracle Database 11g Problem SQL Statements Oracle Optimizer Oracle Database 11g: Problem SQL Statements & Oracle Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command,  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 SQL Tuning Diagnostics and Tuning Schema ...e the steps to be performed for using SQLTrace. Turn on autotrace option in the specified format. Match the various performance analysis tools available tools available for identifying expensive statements with their functions. Unit 3: Tuning the Schema Duration: 2 Hour(s) Identify the levels of B*-tree index structure. Identify the features of a B*-tree index scan.  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...cution plan at the system level for a SQL statement using AUTOTRACE. Identify the symptoms of inefficient SQL statements. Identify the characteristics of optimizer modes. Perform the steps to set the optimizer mode at the instance level using the OPTIMIZER_MODE parameter. Perform the steps to register a module using the SET_MODULE procedure. Perform the steps to track a module using  more...

Oracle8i Performance Tuning Managing Memory Disk I O ...ion plan at the system level for a SQL statement by using AUTOTRACE. Identify the characteristics of optimizer modes. Set the optimizer mode at the session level by using the OPTIMIZER_MODE parameter. Unit 2: Tuning the Shared Pool Duration: 1.5 - 2 Hour(s) Select the contents of the library cache. Identify the contents of the data dictionary cache. Select the functions of the  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the  more...