Lee, S.P. and Zildzic, D. (2006) Oracle database workload performance measurement and tuning toolkit. Issues in Informing Science and Information Technology, 3. ISSN 1547-5840,
Full text not available from this repository.Abstract
Database tuning practice is mainly conducted as a consequence of user's complaints on the performance. There is a need for a reactive monitoring and tuning tool enabling a real-time overview of the main resource consumers in order to detect and solve performance bottlenecks. With an assessment of the Oracle's high-availability database, in terms of the main architectural components and their impact on performance, we have developed a Java tool for the efficient and resource- effective tuning of Oracle databases. Our tool, called Workload Performance Monitoring and Tuning (WPMT), enables proactive and reactive database tuning. By combining today's best monitoring and tuning practices with our metrics management, we have designed a unique approach to illustrate the efficiency of the Oracle database memory segments responsible for handling the workload. This approach consists of developing database memory delta charts, illustrating the efficiency of memory initialization parameters versus component's workload performance.
| Item Type: | Article |
|---|---|
| Funders: | UNSPECIFIED |
| Uncontrolled Keywords: | Database Management Systems, Tuning, Workload Performance |
| Subjects: | T Technology > T Technology (General) |
| Divisions: | Faculty of Computer Science & Information Technology > Department of Software Engineering |
| Depositing User: | Ms Maisarah Mohd Muksin |
| Date Deposited: | 11 Jul 2013 02:10 |
| Last Modified: | 11 Jul 2013 02:10 |
| URI: | http://eprints.um.edu.my/id/eprint/7155 |
Actions (login required)
 |
View Item |
