Perform database tuning on a regular basis to optimize the performance of the database and system resources.
You may perform tuning on a variety of components, such as the following examples:
Database files design
Hardware and software, including the operating system and CPU
Customization of settings and the configuration
Query tuning to improve performance by tuning various elements, such as memory size, type of file system, number and type of processors, and so on
Database indexing to improve the speed of data retrieval operations and potentially save disk space
For information on tuning databases, refer to the documentation listed in Table 28, Database Tuning Documentation.
Table 28. Database Tuning Documentation
| Component | Documentation Library Tab | Documentation |
|---|---|---|
| Essbase | Essbase | Oracle Essbase Database Administrator's Guide |
| Oracle Database | Related | Oracle Database documentation (11g and 10g) |
| Application Server | Related |
|