select /*+ wonjin */ 'x' from dual;
SELECT * FROM v$sql
WHERE SQL_TEXT NOT LIKE '%v$sql%'
AND SQL_TEXT LIKE '%wonjin%'
;
| SQL_TEXT | SQL_ID | CHILD_NUMBER |
| ---------------------------------- | ------------- | ------------ |
| select /*+ wonjin */ 'x' from dual | 32q1t2r53pqvy | 0 |
ALTER system flush shared_pool;
SELECT * FROM v$sql
WHERE SQL_TEXT NOT LIKE '%v$sql%'
AND SQL_TEXT LIKE '%wonjin%'
;
| SQL_TEXT | SQL_ID | CHILD_NUMBER |
| ---------------------------------- | ------------- | ------------ |