VIEW: SYS.V_$SQL_DIAG_REPOSITORY

Source

View Text - Preformatted

select "ADDRESS","CON_ID","HASH_VALUE","SQL_ID","CHILD_NUMBER","SQL_DIAG_REPO_ID","TYPE","PLAN_ID","FEATURE","STATE" from v$SQL_DIAG_REPOSITORY

View Text - HTML Formatted

SELECT "ADDRESS"
, "CON_ID"
, "HASH_VALUE"
, "SQL_ID"
, "CHILD_NUMBER"
, "SQL_DIAG_REPO_ID"
, "TYPE"
, "PLAN_ID"
, "FEATURE"
, "STATE"
FROM V$SQL_DIAG_REPOSITORY