Oracle: Finding (undocumented) hints in the shared SQL area
The following SQL statement tries to find SQL statements with hints in the shared SQL area. When I wrote this statement, I hoped I'd find hints that are undocumented.
select
distinct
regexp_substr(lower(listagg(t.sql_text, '') within group (order by t.piece)), '/\* *\+[^*]*')
from
v$sqltext_with_newlines t
where
piece < 20
group by
sql_id
order by
1;