Knowledge Base : Show sql plan

17 November 1, 2021

Show SQL Execution Plan für given SQL ID:

select * from table(dbms_xplan.display_cursor(‚bk6bt3xs4ykrr‘,0));

See „“Show Top SQL“ for an approach to see relevant SQL IDs.