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'));