Spendius wrote:
> Hi,
> Can the new column PLAN_HASH_VALUE of V$SQL be used
> to join this table to the various V$SQL_PLAN* tables
> (SQL_PLAN, SQL_PLAN_STATISTICS & SQL_PLAN_STATISTICS_ALL) ?
PLAN_HASH_VALUE is a hierarchical aggregated total of the non-volatile
columns from V$SQL_PLAN. (Well, it might be not calculated exactly this
way, but thats the idea).
HASH_VALUE in numerous v$sql derivative views is a surrogate SQL
statement identifier. Numerous other columns (SQL_ID, SQL_SIGNATURE,
ADDRESS) reflect a confusion about what is considered SQL statement
identity.
Received on Thu Sep 08 2005 - 18:52:41 CDT
