Re: How to match hash_value

Hmm that is great, I was having same problem this week when I was creating
some outlines.....

Thanks Jacques


--
LSC

On 2/9/07, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:


Yes, it does.  Thanks Jacques!

Below you can see that the only difference was an extra space (32) I was
missing at the very end and once I added the extra space, I got the
exact same hash_value.

SQL> select hash_value, sql_text, dump(sql_text) from v$sql where
hash_value in (3486651370,1343167348);

HASH_VALUE
----------
SQL_TEXT
------------------------------------------------------------------------
--------
DUMP(SQL_TEXT)
------------------------------------------------------------------------
--------
3486651370
SELECT s1.spec_template_id,s1.spec_id,s2.spec_template_id
ass_spec_template_id,
s2.spec_id ass_spec_id,s1.company_id,
s1.project_id,s1.spec_class_type,s2.spec
_class_type ass_spec_class_type,sa.ass_type  FROM IBS_SPEC s1, IBS_SPEC
s2, IBS_
SPEC_ASSIGNMENTS sa  WHERE s1.spec_id = sa.spec_id  AND s2.spec_id = :1
AND sa.
ass_spec_id = :2
Typ=1 Len=336:
83,69,76,69,67,84,32,115,49,46,115,112,101,99,95,116,101,109,112,
108,97,116,101,95,105,100,44,115,49,46,115,112,101,99,95,105,100,44,115,
50,46,11
5,112,101,99,95,116,101,109,112,108,97,116,101,95,105,100,32,97,115,115,
95,115,1
12,101,99,95,116,101,109,112,108,97,116,101,95,105,100,44,32,32,115,50,4
6,115,11
2,101,99,95,105,100,32,97,115,115,95,115,112,101,99,95,105,100,44,115,49
,46,99,1
11,109,112,97,110,121,95,105,100,44,32,32,115,49,46,112,114,111,106,101,
99,116,9
5,105,100,44,115,49,46,115,112,101,99,95,99,108,97,115,115,95,116,121,11
2,101,44
,115,50,46,115,112,101,99,95,99,108,97,115,115,95,116,121,112,101,32,97,
115,115,
95,115,112,101,99,95,99,108,97,115,115,95,116,121,112,101,44,115,97,46,9
7,115,11
5,95,116,121,112,101,32,32,70,82,79,77,32,73,66,83,95,83,80,69,67,32,115
,49,44,3
2,73,66,83,95,83,80,69,67,32,115,50,44,32,73,66,83,95,83,80,69,67,95,65,
83,83,73
,71,78,77,69,78,84,83,32,115,97,32,32,87,72,69,82,69,32,115,49,46,115,11
2,101,99
,95,105,100,32,61,32,115,97,46,115,112,101,99,95,105,100,32,32,65,78,68,
32,115,5
0,46,115,112,101,99,95,105,100,32,61,32,58,49,32,32,65,78,68,32,115,97,4
6,97,115
,115,95,115,112,101,99,95,105,100,32,61,32,58,50

1343167348
SELECT s1.spec_template_id,s1.spec_id,s2.spec_template_id
ass_spec_template_id,
s2.spec_id ass_spec_id,s1.company_id,
s1.project_id,s1.spec_class_type,s2.spec
_class_type ass_spec_class_type,sa.ass_type  FROM IBS_SPEC s1, IBS_SPEC
s2, IBS_
SPEC_ASSIGNMENTS sa  WHERE s1.spec_id = sa.spec_id  AND s2.spec_id = :1
AND sa.
ass_spec_id = :2
Typ=1 Len=337:
83,69,76,69,67,84,32,115,49,46,115,112,101,99,95,116,101,109,112,
108,97,116,101,95,105,100,44,115,49,46,115,112,101,99,95,105,100,44,115,
50,46,11
5,112,101,99,95,116,101,109,112,108,97,116,101,95,105,100,32,97,115,115,
95,115,1
12,101,99,95,116,101,109,112,108,97,116,101,95,105,100,44,32,32,115,50,4
6,115,11
2,101,99,95,105,100,32,97,115,115,95,115,112,101,99,95,105,100,44,115,49
,46,99,1
11,109,112,97,110,121,95,105,100,44,32,32,115,49,46,112,114,111,106,101,
99,116,9
5,105,100,44,115,49,46,115,112,101,99,95,99,108,97,115,115,95,116,121,11
2,101,44
,115,50,46,115,112,101,99,95,99,108,97,115,115,95,116,121,112,101,32,97,
115,115,
95,115,112,101,99,95,99,108,97,115,115,95,116,121,112,101,44,115,97,46,9
7,115,11
5,95,116,121,112,101,32,32,70,82,79,77,32,73,66,83,95,83,80,69,67,32,115
,49,44,3
2,73,66,83,95,83,80,69,67,32,115,50,44,32,73,66,83,95,83,80,69,67,95,65,
83,83,73
,71,78,77,69,78,84,83,32,115,97,32,32,87,72,69,82,69,32,115,49,46,115,11
2,101,99
,95,105,100,32,61,32,115,97,46,115,112,101,99,95,105,100,32,32,65,78,68,
32,115,5
0,46,115,112,101,99,95,105,100,32,61,32,58,49,32,32,65,78,68,32,115,97,4
6,97,115
,115,95,115,112,101,99,95,105,100,32,61,32,58,50,32


SQL> select hash_value, child_number, executions, sql_text from v$sql
where hash_value = 1343167348;

HASH_VALUE CHILD_NUMBER EXECUTIONS
---------- ------------ ----------
SQL_TEXT
------------------------------------------------------------------------
--------
1343167348            0         53
SELECT s1.spec_template_id,s1.spec_id,s2.spec_template_id
ass_spec_template_id,
s2.spec_id ass_spec_id,s1.company_id,
s1.project_id,s1.spec_class_type,s2.spec
_class_type ass_spec_class_type,sa.ass_type  FROM IBS_SPEC s1, IBS_SPEC
s2, IBS_
SPEC_ASSIGNMENTS sa  WHERE s1.spec_id = sa.spec_id  AND s2.spec_id = :1
AND sa.
ass_spec_id = :2

1343167348            1          1
SELECT s1.spec_template_id,s1.spec_id,s2.spec_template_id
ass_spec_template_id,
s2.spec_id ass_spec_id,s1.company_id,
s1.project_id,s1.spec_class_type,s2.spec
_class_type ass_spec_class_type,sa.ass_type  FROM IBS_SPEC s1, IBS_SPEC
s2, IBS_
SPEC_ASSIGNMENTS sa  WHERE s1.spec_id = sa.spec_id  AND s2.spec_id = :1
AND sa.
ass_spec_id = :2



-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer@xxxxxxxxx]

Would the dump function do the trick?

Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of this company shall be understood as neither given nor endorsed
by it.

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

Other related posts: