Oracle database workload performance measurement and tuning toolkit

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.
Official URL:


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
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

Actions (login required)

View Item View Item