Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V$SQL_PLAN.HASH_VALUE = V$SQL.PLAN_HASH_VALUE ?
I would say no. The description of the coulmn in the Oracle version#
Reference manual states the column is used to determine if two SQL
statements are the same statement.
It would appear that address and hash_value are still the join columns for these views from the view descriptions.
You can find all copies of the same sql_text in v$sql using the plan_hash_value column.
HTH -- Mark D Powell -- Received on Thu Sep 08 2005 - 09:57:30 CDT