Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$SQL_PLAN.HASH_VALUE = V$SQL.PLAN_HASH_VALUE ?

Re: V$SQL_PLAN.HASH_VALUE = V$SQL.PLAN_HASH_VALUE ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Sep 2005 07:57:30 -0700
Message-ID: <1126191450.683998.242410@g14g2000cwa.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US