execution plan - cheeyoung/sqlplus-public GitHub Wiki

DBMS_XPLAN package

From
cached cursor	display_cursor	sql_id, cursor_child_no	format
workload repository	display_awr	sql_id, plan_hash_value	format

Views ()

• From cached cursor to workload repository

SET AUTOTRACE (SQL*Plus)

EXPLAIN PLAN statement (DML)

References

9.1 About Tracing Statements

13.41.6 SET AUTOTRACE