RE: Hash value

just checked in a 10.4.0.1 and it is still a number :

> dsk v\$session -u sys | grep -i hash_value

 SQL_HASH_VALUE                                     NUMBER
 PREV_HASH_VALUE                                    NUMBER



> dsk v\$sql -u sys | grep -i hash_value

 OPTIMIZER_ENV_HASH_VALUE                           NUMBER
 HASH_VALUE                                         NUMBER
 OLD_HASH_VALUE                                     NUMBER
 PLAN_HASH_VALUE                                    NUMBER
 LITERAL_HASH_VALUE                                 NUMBER

I think you mix sql_id with hash_value

B. Polarksi

-----Original Message-----
From: rjamya [mailto:rjamya_at_gmail.com]
Sent: Thursday, 21 September, 2006 1:30 PM To: adi_at_zetapoint.com
Cc: oracle-l_at_freelists.org
Subject: Re: Hash value

none that I know of. BTW that hash function changed in 10g, since the HV are alphanumeric instead of numeric only.

Raj

On 9/21/06, Adi Hirschtein <adi_at_zetapoint.com> wrote:
>
> Hi Guys,
> I'm trying to calculate the hash value of statements as oracle does in

> the v$sqlarea.
>

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





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