The DBMS_XPLAN DISPLAY_AWR function displays an execution plan from the AWR
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 |
| PLAN_HASH_VALUE | NUMBER(38) | IN | DEFAULT |
| DB_ID | NUMBER(38) | IN | DEFAULT |
| FORMAT | VARCHAR2 | IN | DEFAULT |
| CON_ID | NUMBER | IN | DEFAULT |