| 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? | ||
Examples of Measurable
Tuning Goals
| 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 |