Online Tkprof 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 ...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 level by using the OPTIMIZER_MODE parameter. Unit 2: Tuning the Shared Pool Duration: 1.5 - 2 Hour(s)  more...

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

Oracle SQL Tuning Diagnostics and Tuning Schema ...ter file. Switch on SQL Trace. Match the columns in the TKPROF output with their descriptions. Match the TKPROF timing output columns with their descriptions. Identify the additional components of the TKPROF output. Sequence the steps to be performed for using SQLTrace. Turn on autotrace option in the specified format. Match the various performance analysis tools available tools  more...