select srh.hint_id, srh.hint_text, srh.reparse, 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 ;