Re: Question about parsing

Looking at your next post with the HTML of the v$sql dump, note how the hash_value column shows different values for the two queries. Whatever you may think, the two texts arriving at the server are NOT the same.

Perhaps the jdbc link is doing something to normalise the SQL before is sends it, e.g. eliminating spaces and new-lines, so that the arriving text is not exactly what you think it should be.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Julio German Rojas Pelaez wrote in message ...


>In short:

>I have exactly same query once executed though jdbc once executed from

>sqlplus.

>I got two different rows in v_$sql.

>

>Should't they be registered as two executions of the same query instead of

>two

>different ones?

>

>

>

>

>

>More information:

>The reason of this question is trying to find why the query through jdbc

>gets locked

>with an library cache pin exclusive every time it is executed.

>I have tried to reproduce the lock executing the same query through sqlplus

>I have

>verified the cloning of the query through:

>

>SELECT ADDRESS, SQL_TEXT || '|' FROM V_$SQLTEXT

>WHERE

>ADDRESS IN ('81EEB098' , '820C3F88' )

>order by  piece, address

>

>they are piece by piece identical.

>On a follow up I include the contents of V_$SQL for these queries (HTML

>formated)

>

>If  the answer to above question is 'YES' something has gone wrong with

>oracle and

>that would be my next searching if 'NO' will have to  continue looking for

>something

>else.

>

>

>