DBA Data[Home] [Help]

VIEW: SYS.V_$SQL_REOPTIMIZATION_HINTS

Source

View Text - Preformatted

select "ADDRESS","HASH_VALUE","SQL_ID","CHILD_NUMBER","HINT_ID","HINT_TEXT","CLIENT_ID","REPARSE","CON_ID" from v$sql_reoptimization_hints
View Text - HTML Formatted

SELECT "ADDRESS"
, "HASH_VALUE"
, "SQL_ID"
, "CHILD_NUMBER"
, "HINT_ID"
, "HINT_TEXT"
, "CLIENT_ID"
, "REPARSE"
, "CON_ID"
FROM V$SQL_REOPTIMIZATION_HINTS