Oracle SQL Performance Analyzer (SPA) is part of Real Application Testing pack. We can use SPA to validate changes made to the database system. Some of these changes include gathering statistics, creating SQL Profiles or making parameter changes.
In one of my previous posts I provided detailed information on how to use SPA.
The video below provides better context and flow on how to use SPA to validate if a SQL Profile works as expected.