Application & Database Tuning

A local client providing an Internet application that allows external customers to scan, archive and retrieve documents, experienced an increase in the volume of business documents scanned by the application, which resulted in unacceptable response times.

Celeritas conducted a thorough performance evaluation, including a review of the Oracle database, database indexes, SQL queries, and the J2EE architecture. The Celeritas Database Configuration Report and the Oracle Statspack utility were used to evaluate the database performance. Once the resource-intensive SQL statements were identified, the Oracle Explain Plan utility was used to tune the SQL statements. Several of the SQL statements were optimized to attain sub-second response time compared to the original 2-3 minute response time.