Case Study: Large Enterprise Telecommunications Company achieves 400% database performance gains with Idera Precise

Telecomm Enterprise Improves Database Performance by Almost 400%

A Large Enterprise Telecommunications Company needed to speed up a midnight batch job that collected configuration and performance data for a third-party reporting application running on Oracle Database. The job was taking 12 hours to process 2,000 servers, delaying analysts’ morning capacity planning work, and the company expected to scale to 6,000 servers without modifying the application’s source code. Idera’s Precise for Oracle Database was used to investigate the slowdown.

Idera identified a small set of SQL statements causing most of the database time, recommended missing index changes, and then uncovered additional issues with uncached Oracle sequences and cursor sharing settings. After implementing these fixes, the company cut batch runtime from 12 hours to 2.5 hours, reduced Oracle time spent by the job from 90% to 20%, and was able to process 6,000 servers in less than 8.5 hours while avoiding a hardware upgrade.