oradebug dump cursortrace

SQL> oradebug doc event action cursortrace
CURSORTRACE
        - Trace cursor by hash value (hash value is address)
Usage
-------
CURSORTRACE( level           <ub4> default '1',
             addr            <pointer>,
             address         <pointer>)

select /*+ tq84 */ … from …;

select hash_value, sql_text from v$sql where sql_text like '%tq84%';

oradebug dump cursortrace 612 <hash-value>

select /*+ tq84 */ … from …;

alter system set events 'immediate trace name cursortrace level 612, address hash_value';