|
|
|
|
|
After completing this lesson, you should be able
to |
|
do the following: |
|
List the roles associated with the database
tuning process |
|
Define the steps associated with the tuning
process |
|
Identify tuning goals |
|
|
|
|
|
Who tunes? |
|
Application designers |
|
Application developers |
|
Database administrators |
|
System administrators |
|
Why tune? |
|
How much tuning? |
|
|
|
|
Response time |
|
Database availability |
|
Database hit percentages |
|
Memory utilization |
|
|
|
|
Access the least number of blocks |
|
Cache blocks in memory |
|
Share application code |
|
Read and write data as quickly as possible |
|
Ensure that users do not wait for resources |
|
Perform backups and housekeeping while
minimizing impact |
|
|
|
|
1. Tune the design. |
|
2. Tune the application. |
|
3. Tune memory. |
|
4. Tune I/O. |
|
5. Tune contention. |
|
6. Tune the operating system. |
|
|
|
|
In this lesson, you should have learned that it
is |
|
important to: |
|
Create a good initial design |
|
Define roles clearly |
|
Perform application tuning |
|
Establish quantifiable goals |
|
Notes