explain plan statement. plan_table: the value is found in the column statement_id: explain plan
set statement_id = 'st1'
for
select
foo, bar, baz
from
tab;
…
select … from plan_table where statement_id = 'st1';
dbms_xplan.display. select * from dbms_xplan.display(statement_id => 'st1'));