RelationalDBDesign
RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Performance Tuning
«Prev
Next»
Performace Tuning Basics
Exam Preparation
Oracle Performance Tuning
Tuning Tequirements
Alert Files
Trace Files
Lesson 9
Oracle Performance Tuning (Conclusion)
This module has served as a high-level overview of Oracle tuning. While we will address the details later, you should now be able to:
Describe the layout of Oracle components
Describe how database design effects performance
Contrast third normal form with de-normalized design
Describe the characteristics of a high-performing database
Identify Oracle physical components that effect performance
Identify five Oracle components that can be tuned
Describe the metrics of Oracle performance
New terms
Here are the terms from this module that may be new to you.
Logical database design
Physical database design
Performance metrics
Logical database design tuning
Physical table design tuning
SQL tuning
SGA tuning
Environmental tuning
We will look at the business requirements of tuning.
Performance Tuning Overview - Quiz
Now let us wrap-up this module with a quiz.
Performance Tuning Overview - Quiz