IGNORE_OPTIM_EMBEDDED_HINTS - no_merge

test-output.sql

SQL> set feed on sql_id
SQL> select/*+ no_merge 123 */ * from dual;

D
-
X

1 row selected.

SQL_ID: 6zsqx79h3usgq
SQL> set feed off
SQL> @profiles/patch_create
***
Using SQL Patch to add hints
***
SQL_ID: 6zsqx79h3usgq
Hints: IGNORE_OPTIM_EMBEDDED_HINTS
Patch name: p_drop
Description: IGNORE_OPTIM_EMBEDDED_HINTS

SQL Profile p_drop created on instance #1
Results:
p_drop

SQL> select/*+ no_merge 123 */ * from dual;

D
-
X

SQL> @plan 6zsqx79h3usgq +hint_report

Childs:

CHILD_NUMBER
------------
           0

P_CHILD      P_FORMAT
------------ ---------------------------
             typical +hint_report


PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------
SQL_ID  6zsqx79h3usgq, child number 0
-------------------------------------
select/*+ no_merge 123 */ * from dual

Plan hash value: 272002086

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      |       |       |     2 (100)|          |
|   1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |
--------------------------------------------------------------------------

Hint Report (identified by operation id / Query Block Name / Object Alias):
Total hints for statement: 2 (U - Unused (1))
---------------------------------------------------------------------------

   0 -  STATEMENT
           -  IGNORE_OPTIM_EMBEDDED_HINTS

   1 -  SEL$1
         U -  no_merge / rejected by IGNORE_OPTIM_EMBEDDED_HINTS

Note
-----
   - SQL patch "p_drop" used for this statement