Question: What are the
exact_matching_signature and force_matching_signature
columns in the Oracle dictionary.
Answer: The dictionary columns
exact_matching_signature, and force_matching_signature exist
in v$sqlarea, v$sql, stats$sql_summary and
The Oracle docs note that
these signature columns are "normalized" (e.g. standardized"
representations of SQL statements, thereby allowing them to
be compared with dictionary queries:
[is] calculated on the normalized SQL text. The
normalization includes the removal of white space and the
uppercasing of all non-literal strings." It also says that
FORCE_MATCHING_SIGNATURE is a "signature used when the
CURSOR_SHARING parameter is set to FORCE".
force_matching_signature and cursor_sharing. and
finding similar SQL in Oracle.