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_at_oneneck.com> 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_at_quest.com]
>
> 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
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 10 2007 - 04:30:29 CST
