DBA Data[Home] [Help]

VIEW: SYS.GV_$MAPPED_SQL

Source

View Text - Preformatted

select "INST_ID","SQL_TEXT","SQL_FULLTEXT","SQL_ID","HASH_VALUE","MAPPED_SQL_TEXT","MAPPED_SQL_FULLTEXT","MAPPED_SQL_ID","MAPPED_HASH_VALUE","SQL_TRANSLATION_PROFILE_ID","CON_ID" from gv$mapped_sql
View Text - HTML Formatted

SELECT "INST_ID"
, "SQL_TEXT"
, "SQL_FULLTEXT"
, "SQL_ID"
, "HASH_VALUE"
, "MAPPED_SQL_TEXT"
, "MAPPED_SQL_FULLTEXT"
, "MAPPED_SQL_ID"
, "MAPPED_HASH_VALUE"
, "SQL_TRANSLATION_PROFILE_ID"
, "CON_ID"
FROM GV$MAPPED_SQL