Oracle's SQL Performance Analyzer

  title={Oracle's SQL Performance Analyzer},
  author={Khaled Yagoub and Peter Belknap and Beno{\^i}t Dageville and Karl Dias and Shantanu Joshi and Hailing Yu},
  journal={IEEE Data Eng. Bull.},
We present the SQL Performance Analyzer, a novel approach in Oracle Database 11g to testing database changes, such as upgrades, parameter changes, schema chang es, d gathering optimizer statistics. The SQL Performance Analyzer offers a comprehensive solution t o e able users to forecast and analyze how a system change will impact SQL query plans and run time perfo rmance, so they can tune their system before they make the change in production. The SQL Performan ce A alyzer identifies potential… CONTINUE READING
Highly Cited
This paper has 18 citations. REVIEW CITATIONS