Re: Very long queries in V$SQLTEXT

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 25 Nov 1999 22:38:10 -0000
Message-ID: <943569735.24906.0.nnrp-09.9e984b29@news.demon.co.uk>

Two ideas -

First, select the 'piece' as well just to see what they are.

Second use the 'hash_value' in the query as well; it shouldn't make any difference, but if you have a high-bit / 32 bit / 64 bit problem between the various v$
objects , perhaps your are getting
spurious sections of other dead queries mixed in with the live query.

Third (shades of the Spanish Inquisition) check and compare v$sqltext_with_newlines.

Fourth (and scraping the barrel) could there be an issue with embedded line-feeds or other non-printing characters which are causing your terminal output to hide sections of line.

Fifth - could you please spell my name
correctly.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <383D297D.FBA_at_yahoo.com>...
>Jonathan Lewis wrote:
>>
>> Could you be more specific about
>> what you think is nonsense ?
>>
Received on Thu Nov 25 1999 - 16:38:10 CST