Online Explain Plan eLearning Training

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...

Oracle8i Performance Tuning Managing Memory Disk I O ...- 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...

Oracle8 Performance Tuning Managing Memory and Disk I O ...f 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 level more...

Oracle SQL Tuning Diagnostics and Tuning Schema ... Duration: 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...