Online Explain Plan eLearning

Explain Plan Training Provider? - Tell us about your Training!
Explain Plan Training Seminars and Classes
From 123-CBT Computer Based Training
Oracle Database 11g Problem SQL Statements Oracle Optimizer on-line e-learning cbt (computer based)cd rom ...nd view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command, SQL*Plus AUTOTRACE command options, and the V$SQL_PLAN view. The functions of the Optimizer and how to influence and control the optimizer's behavior is discussed in detail, including the various query access paths that can be used, when to use different join methods and sort operations, how to manage and maintain  more...
Oracle Database 11g Execution Plans and Star Transformations on-line e-learning cbt (computer based)cd rom 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 on-line e-learning cbt (computer based)cd rom ...uration: 2 - 3 Hour(s) Match the identifiers in the EXPLAIN PLAN command with their descriptions. Match the columns in the EXPLAIN PLAN output table with their descriptions. Identify the combination of operation and option used, given the interpretation of the EXPLAIN PLAN output. Display the execution plan worked out by the optimizer for a given query by using the EXPLAIN PLAN  more...
Oracle8 Performance Tuning Managing Memory and Disk I O on-line e-learning cbt (computer based)cd rom ... a hash join process when a hash join is built. Use the EXPLAIN PLAN statement to explain the plan for a query. Perform the procedure to set trace up at the session level to look at the performance of a plan. Perform the steps to use TKPROF to report the trace statistics in readable form and interpret the output file. Perform the procedure to generate an execution plan at the system  more...
Oracle8i Performance Tuning Managing Memory Disk I O on-line e-learning cbt (computer based)cd rom ...- 2 Hour(s) Explain the plan for a query by using the EXPLAIN PLAN statement. Inspect the performance of a plan by setting up trace at the session level. Match the TKPROF options with their respective descriptions. Generate an execution 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  more...
Oracle9i Peformance Tuning Managing Memory and Disk I O on-line e-learning cbt (computer based)cd rom 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...
Do you offer Explain Plan training?
Custom Search
tcw11--02/14/12-10:30:26-(862)[B]-[B]-[B]