Oracle: V$SQL_REOPTIMIZATION_HINTS

select
   srh.hint_id,
   srh.hint_text,
   srh.reparse,
   sql.is_reoptimizable,  -- Always = 'Y' ?
   sql.first_load_time,
   sql.*
from
   v$sql_reoptimization_hints srh                                           join
   v$sql                      sql on srh.address      = sql.address     and
                                     srh.hash_value   = sql.hash_value  and
                                     srh.child_number = sql.child_number
-- where
--    srh.sql_id = 'aqs87yn1yhw2j'
order by
   sql.sql_id,
   sql.child_number,
   srh.hint_id
;