Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Outlines: hash value in OL$
Jonathan,
Thanks for responding.
I am asking because my outline is not working - I am following
Metalink 92202.1 to perform a "swap" of two outlines in order
to modify execution path of SQL statement in Oracle Forms FMX
file. While I can get it to work in SQL*Plus it does not work
for the actual statement in Forms. From reading various posts
on the Metalink and this newsgroup I had impression that by comparing
hash values I'll be able to make sure that the statements are equal.
As I don't have access to Forms code I do not know what exactly statement
is there (i.e. whether there are any spaces, etc), and in OL$ it is LONG column...
While my question was about 9.2.0 the actual system is 8.1.6.
Regards,
Sev
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<bugu99$oes$1_at_sparta.btinternet.com>...
> Are you asking because you think you have
> found a problem, or out of idle curiosity.
> If the latter, you may be interested to note
> that in 8.1, the two following statements
> have different hash values in v$sql:
>
> SELECT COUNT(*) FROM DUAL;
>
> SELECT COUNT(*) FROM DUAL
> ;
>
> Oracle doesn't document ol$ (much) because
> we don't really need to know. In passing,
> ol$ uses the signature to identify texts, rather
> than the hash_value, so it doesn't really matter
> that v$sql and ol$ get different hash values.
>
> Perhaps the two hash values are attempts by
> Oracle to use modified versions of the original
> hash-value algorithm to reduce collisions.
>
>
> --
> Regards
>
> Jonathan Lewis
Received on Wed Jan 21 2004 - 16:27:27 CST