Re: Buffer Gets question

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 4 May 2017 07:14:04 -0600
Message-Id: <4260871B-59A6-4EAC-8E7F-61313F85AE20_at_centrexcc.com>

Same plan hash value doesn’t guarantee that it is the same plan. Not so much because of possible hash collisions but mainly because not every plan detail goes into the making of the hash value.

Wolfgang Breitling
breitliw_at_centrexcc.com

> On May 3, 2017, at 6:37 AM, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
>
> The query has the exact same plan hash value in both systems, which is 3209742519

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 04 2017 - 15:14:04 CEST

This message: [ Message body ]
Next message: Svetoslav Gyurov: "Re: Oracle Audit Vault and Database Firewall"
Previous message: Freeman, Donald G. CTR: "OEM 13C install problem"
In reply to: Hameed, Amir: "RE: Buffer Gets question"
In reply to Hameed, Amir: "RE: Buffer Gets question"
Next in thread: Svetoslav Gyurov: "Re: Oracle Audit Vault and Database Firewall"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message