Explain Plan Using Statement ID.

SQL>explain plan set statement_id = 'TEST' FOR select * from scott.EMP;

Explained.


SQL>@explain TEST





PLAN                      OBJECT_NAME    OBJECT_TYPE  BYTES    COST     PARTITION_START      PARTITION_STOP
---------------------     ------------   ------------ -------- -------- -------------------- --------------
Select Statement                                      1218        3
  1.1 Table Access (Full) EMP            TABLE        1218        3