Files
notes/tiddlywiki/dbms_xplan - examples.txt
2026-03-12 22:01:38 +01:00

9 lines
243 B
Plaintext
Executable File

-- for a cursor in library cache
set pages 999 lines 200
select * from table(dbms_xplan.display_cursor('&&SQL_ID',null,null));
-- from AWR
set pages 999 lines 200
select * from table(dbms_xplan.display_awr('&&SQL_ID',null,null,'ADVANCED'));