Re: Sql-id value: does it chage and what evet changes it?

From: amonte <ax.mount_at_gmail.com>
Date: Fri, 6 Mar 2009 18:24:53 +0100
Message-ID: <85c1fb130903060924g6ad42dfdyb2e9d66c203dd163_at_mail.gmail.com>

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

Alex

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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Fri Mar 06 2009 - 11:24:53 CST