DB Wiki

Adaptive Plans in Oracle Database 12c allow runtime changes to execution plans.
At runtime the cardinality of operations is checked and compared to the cardinality estimates used to generate the execution plan. If the cardinality of the operation is not as expected, an alternative subplan can be used.

To view the whole adaptive plan run the following after you SQL statement

SELECT * FROM TABLE(DBMS_XPLAN.display_cursor(format => 'adaptive'));

Use the following to also see the expected and actual cardinalities.

SELECT * FROM TABLE(DBMS_XPLAN.display_cursor(format => 'adaptive allstats last'));