Online Explain Plan eLearning - Training Resources
Explain Plan Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based 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...
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...
...- 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...
...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...
... 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...
From Teach Me IT
Optimizing and Securing an Oracle8 Data Warehouse
Optimizing and Securing an Oracle8 Data Warehouse is the third course of the Oracle8 Data Warehousing curriculum. This course acquaints users to the various methods that can be employed to secure and optimize an Oracle8 data warehouse. The course explains the concepts of tuning the data warehouse, creating backups, recovering and archiving data. The course extensively covers aspects related to
more...
Optimizing and Securing an Oracle8 Data Warehouse is the third course of the Oracle8 Data Warehousing curriculum. This course acquaints users to the various methods that can be employed to secure and optimize an Oracle8 data warehouse. The course explains the concepts of tuning the data warehouse, creating backups, recovering and archiving data. The course extensively covers aspects related to
more...
