Oracle7 Server Tuning
Who Tunes?
Several people must exchange information and become involved in the tuning process to tune the system effectively. For example:
- The application designer must communicate the system design so that everyone can understand the flow of data in an application.
- The application developers must communicate the implementation strategies they choose so that modules and SQL statements can be quickly and easily identified during statement tuning.
- The database administrator must carefully monitor and document system activity so that unusual system performance can be identified and corrected.
- The hardware/software administrators must document and communicate the hardware software configuration of the system so that everyone can design and administer the system effectively.
In short, everyone involved with the system has some role in the tuning process. When the people mentioned above communicate and document the system's characteristics, tuning becomes significantly easier and faster.
In practice, unfortunately, the database administrator usually has the primary responsibility for tuning. Also, the database administrator rarely has adequate documentation of the system. The section "Tuning a Production System" describes how database administrators can identify performance problems given little or no information from the application designers.