Check SQL Query using adaptive execution plan in Oracle

select sql_id, child_number, sql_text, IS_RESOLVED_ADAPTIVE_PLAN from v$sql
where Is_RESOLVED_ADAPTIVE_PLAN = 'Y';

IS_RESOLVED_ADAPTIVE_PLAN column in V$SQL view:

This column shows whether all of the adaptive parts of a plan have been resolved to the final plan. Once the plan is resolved, the plan hash value and the plan displayed by DBMS_XPLAN will not change through the end of execution. The values for this column are:

• NULL: If the plan is not adaptive
• Y: If the plan is fully resolved
• N: If the plan is not yet fully resolved

Reference: https://docs.oracle.com/database/121/REFRN/GUID-2B9340D7-4AA8-4894-94C0-D5990F67BE75.htm#REFRN30246