RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Oracle Instance
«Prev
Next»
Tuning Oracle Instance
Instance Tuning
Main Components SGA
Oracle Library Cache
Query Dictionary Cache
Shared Pool Tuning
Shared Pool Optimal Tuning
Pin Packages Shared Pool
Pinning Memory Objects
Reserved Size
Shared Pool Reserved Size
Tuning Parameters
Identifying High Use Packages
Identify Swapped out Items
Detecting Library Cache Contention
Reduce Fragmentation
Library Cache Statistics
Reuse SQL Library Cache
Tuning Shared Pool
Data Buffer Cache
Tuning Data Buffer
Calculate buffer Hit Ratio
Non- Full table Scan
Full table Scan
Impact Adding Data Buffers
Predict Amount Spare Memory
Create multiple Buffer Pools
Configure Multiple Buffer Pools
Size Buffer Pools
Monitor Buffer Cache
Use Table Caching
Databuffer Cache Conclusion
Redo Log Tuning
log_checkpoint_interval
RedoLog Wait Statistics
size Archived RedoLog FileSystem
RedoLogs Online Size Determination
Sorting Operations
Oracle Sorting Basics
Monitoring Temp Tablespace
sort_direct_writes
Tuning Oracle Locks
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.
Submit