Redo Log Buffer - Exercise

Tuning Considerations of Redo log buffer

SGA Performance Issues

Objective:Describe typical performance problems related to the Oracle SGA.

Exercise scoring

This exercise is worth a total of 12 points total - four points for each correct answer. To receive full credit, you will need to respond to the three questions below and submit your answers.

Instructions

In this module you have learned about the main components of the SGA and some of the basic tuning issues related to these components. Based on what you know so far, describe some of the performance problems you would expect to encounter for each area of the SGA.

Question 1

What are two examples of performance problems would you expect to come from components of the shared pool? How would you address these problems?

Question 2

What is one kind of performance problem that you would expect to originate in the redo log buffer? How would you address this problem?

Question 3

Describe a performance problem that might occur in the data buffer cache. How would you address this problem?

Submitting your exercise

Once you have entered your responses into the text boxes, click Submit to submit the exercise.
Remember that you must submit all your responses to this exercise at the same time.