DBMS_XPLAN DISPLAY_SQLSET Function

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