Files
oracle/Kevin_Meade/showplan11g.sql

8 lines
163 B
MySQL
Raw Permalink Normal View History

2026-03-12 21:23:47 +01:00
--
-- dump the most recent plan from the plan_table
--
-- usage is: @SHOWPLAN11G
--
select * from table(dbms_xplan.display('PLAN_TABLE',NULL,'ADVANCED'));