Tuning Oracle Instance
Main Components SGA
Oracle Library Cache
Query Dictionary Cache
Shared Pool Tuning
Pin Packages Shared Pool
Shared Pool Reserved Size
library Cache Statistics
Data Buffer Cache
Monitor Buffer Cache
Full table Scan
Calculate buffer Hit Ratio
Redo Log Tuning
RedoLog Wait Statistics
size Archived RedoLog FileSystem
RedoLogs Online Size Determination
Oracle Sorting Basics
Monitoring Temp Tablespace
Redo Log Buffer - Exercise
Tuning considerations of the redo log buffer
SGA performance issues
Describe typical performance problems related to the Oracle SGA.
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.
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.
What are two examples of performance problems would you expect to come from components of the shared pool? How would you address these problems?
What is one kind of performance problem that you would expect to originate in the redo log buffer? How would you address this problem?
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
to submit the exercise.
Remember that you must submit all your responses to this exercise at the same time.