RelationalDBDesign RelationalDBDesign 

Business Requirements   «Prev  Next»

Tuning process - Exercise

Define the steps associated with the tuning process

The steps in the tuning process

Objective: Put the steps in the tuning process in the correct order.


Below are 4 steps to follow whenever a problem is reported. They are presented out of order. Drag the steps into the correct order, with the first step at the top of the list. When you think you have the steps in the correct order, click Done. You will be told whether or not the order is correct. If you didn't get the order right, keep trying. If you get stuck, try clicking Hint. The steps you have in the correct place will have green lights next to them. The steps that are not in the correct place will have red lights next to them. When you're ready for an explanation, click the Submit button.

Exercise Scoring

You will receive 2 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

  1. Verify that there are no network slowdowns|or transmission bottlenecks.
  2. Verify that the CPU and memory overloaded,|check for I/O bottlenecks for each disk.
  3. Check the V$ performance views for problems|such as high redo log space requests,|amount of SGA free memory,|and held locks within the storage pool.
  4. Run an elapsed-time Oracle report using|utlbstat.sql and utlestat.sql.