Performance Tuning using Trace Files

Performance Tuning using Trace Files

Abstract

This Case Study outlines the performance tuning techniques applicable to Custom development/support environments and illustrates them with the help of a case study of a successful Oracle report query performance-tuning carried out at one of our client site. Here we demonstrate how we successively tuned a non-terminating query operating on the real data to complete in less than 30 minutes.

The experiment carried out with a random subset of data containing 17 Million records exhibited 6.5x performance improvement. As the case study in this paper uses Oracle 10g as the database server, some of the performance tuning tips given in this paper would be specific to Oracle.

Download the Case Study

Keywords: Performance tuning, Tables, index tuning and

Author: Rajendra Kumar

Doyen Systems Pvt Ltd.

Related Posts

About the Author

Leave A Comment