From Oracle FAQ
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.
- Automated capture of SQL workload
- Execute SQL pre-change
- Optimize/ Make changes
- Execute SQL post-change
- Compare and report on SQL performance gains