Managing the high-availability databases: Workload performance measurement and tuning of high-availability oracle databases - Softcover

Zild?i?, D?emal

Softcover

ISBN 10: 3639172450 ISBN 13: 9783639172454

Publisher: VDM Verlag Dr. Müller, 2009

Synopsis

A requirement of any mission-critical database- driven applications is to have the information available and to be able to process it as fast as possible. To fulfill this requirement, the database should have a high-availability feature as well as the optimal workload performance. 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 solution for the efficient and resource- effective tuning of Oracle databases. Our solution consists of a tuning strategy, implemented with a custom developed tool, enabling proactive and reactive database tuning. With the proposed tuning strategy and a set of SQL query scripts implemented in custom developed Java tool, we have demonstrated that our tool can be used for the measurement of the main Oracle database component?s workload performance and object optimization, in order to achieve and maintain the optimal database workload performance.

Edition details

• Publisher: VDM Verlag Dr. Müller
• Publication date: 2009
• Language: English
• ISBN 10: 3639172450
• ISBN 13: 9783639172454
• Binding: Paperback
• Number of pages: 104