Query Optimizer  «Prev  Next»

Monitoring Oracle Performance - Exercise

Objective: Identify the different tools available to monitor performance.

Exercise Scoring

Match items in the left column with the items in the right column. When you have completed the exercise, click the Submit button to receive full credit.

Instructions

In the left column below are four terms and their corresponding definitions in the right column. When you think you have all of the terms and their definitions matched correctly, click the Submit button and you will see a result set on the following page. When you have completed the exercise, click the Submit button to see the correct answers.

  1. EXPLAIN PLAN
  2. TKPROF
  3. V$SESSION_LONGOPS
  4. Oracle Enterprise Manager
  1. Works off of statistics gathered|||with the Trace utility
  2. Multifaceted tool for gathering information|||about the operations of your Oracle8i database
  3. Used to provide a step-by-step|||exposition of the execution plan
  4. Real-time information about|||operations such as backup and recovery