From Oracle FAQ
Jump to: navigation, search

DBMS_SQLPA is a new PL/SQL package introduced in Oracle 11g for analysing SQL performance. This package helps users to predict the impact of system changes on SQL statements and fix potential regressions.

Main functions:

  • Automated capture of SQL workload
  • Execute SQL pre-change
  • Optimize/ Make changes
  • Execute SQL post-change
  • Compare and report on SQL performance gains