This whitepaper explains in detail why SQL plan management should be an integral part of the database equation. With many applications upgrading from previous versions of the database, this technology gets more enhanced with each release. This is accomplished through a series of auto task jobs that are detailed.
SQL Plan Management Oracle 12c 12.2 Jan 2017
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