display | Display a plan that is generated by explain plan |
display_cursor | Displays the plan of a cursor in the shared SQL area. |
display_sqlset | Execution plans in an SQL tuning set. |
display_sql_plan_baseline | Displays plans stored in the SQL plan baseline history. |
display_workload_repository | Displays plans for SQL statements found in the Automatic Workload Repository (Views selected from seem to include DBA_HIST_SQL_PLAN, AWR_ROOT_SQL_PLAN, AWR_PDB_SQL_PLAN, DBA_HIST_SQLTEXT, AWR_ROOT_SQLTEXT and AWR_PDB_SQLTEXT) |
display_awr | Deprecated. Displays plans that are found in the Automatic Workload Repository. |
display
The format parameter allows to specify some additional data that is returned by dbms_xplan, for example:
select * from table(dbms_xplan.display(format => 'basic +hint_report'));
select * from table(dbms_xplan.display(format => 'typical' ));
select * from table(dbms_xplan.display(format => '+alias' ));
select * from table(dbms_xplan.display(format => 'advanced' ));
See also MOS Note 2735444.1 (Calling format => '+ hint_report')