(Christian Antognini) You can use the V$SQL.IS_RESOLVED_ADAPTIVE_PLAN column to know whether the execution plan associated to a child cursor is adaptive or not.
/membership]
Read More (Community content)
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help