dbms_xplan.display_cursor call example

run_sql.sql

select * 
from table(
    dbms_xplan.display_cursor(
        ( SELECT max(sql_id) keep (dense_rank first order by last_active_time desc)
          FROM V$SQL
          WHERE lower(sql_text) LIKE 'select /*+ gather_plan_statistics %'), 
        '', 
        'ALLSTATS ADVANCED LAST +PEEKED_BINDS'
    )
);