Great article explaining this
Using SQL Plan Management to Control SQL Execution Plans
SQL Tuning
SQL SPM Ask Tom
SQL Tuning Guide
Tools Internal To The Database
ADDM
SQL Tuning Advisor
SQL Access Advisor
SQL Plan Management
SQL Performance Analyzer
In Oracle 12.2 you can filter the capture dbms_spm
also in 12.2 you can load directly from AWR
COE SQL Profile comes with SQLT