The DBMS_XPLAN DISPLAY_CURSOR function displays an execution plan from the library cache
The function returns a DBMS_XPLAN_TYPE_TABLE
In Oracle 12.1.0.2 the function takes the following parameters:
Argument Name | Type | In/Out | Default? |
SQL_ID | VARCHAR2 | IN | DEFAULT |
CURSOR_CHILD_NO | NUMBER(38) | IN | DEFAULT |
FORMAT | VARCHAR2 | IN | DEFAULT |