Re: Sql-id value: does it chage and what evet changes it?
Date: Fri, 6 Mar 2009 18:24:53 +0100
You observation is correct, sql_id/hash value does not change if SQL text remains constant (or Oracle change their hashing algorithm someday?)
Bear in mind that sql id/hash values are not unique so some sql text can share same values
On Fri, Mar 6, 2009 at 5:52 PM, FMHabash <fmhabash_at_gmail.com> wrote:
> Hi all,
> I have done some testing and found out as long as sql-text does not change,
> sql-id remains same even if...
> 1- db reboots.
> 2- sql ages out of lib cache
> 3- sql changes exec plan.
> Can someone confirm/rebut these findings please.
> Thank you.