The DBMS_XPLAN DISPLAY_SQLSET function displays an execution plan from a SQL tuning set.
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? |
SQLSET_NAME | VARCHAR2 | IN | DEFAULT |
SQL_ID | VARCHAR2 | IN | DEFAULT |
PLAN_HASH_VALUE | NUMBER(38) | IN | DEFAULT |
FORMAT | VARCHAR2 | IN | DEFAULT |
SQLSET_OWNER | VARCHAR2 | IN | DEFAULT |