RE: Hash value
- From: "Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>
- To: <rjamya@xxxxxxxxx>,"oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Sep 2006 14:27:27 +0200
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@xxxxxxxxx]
Sent: Thursday, 21 September, 2006 1:30 PM
To: adi@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx> wrote:
>
> Hi Guys,
> I'm trying to calculate the hash value of statements as oracle does in
> the v$sqlarea.
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
