O'Reilly logo
  • Denis Kozlov thinks this is interesting:

SELECT * FROM TABLE (DBMS_XPLAN.display_awr ('6xvp6nxs4a9n4'));

From

Cover of Expert Oracle SQL

Note

Display plan from AWR (Automatic Workload Repository)