Re: Why is sort segment growing extremely big on simple query?

From: Don Vaillancourt <donv_at_webimpact.com>
Date: Tue, 09 Nov 2004 11:09:09 -0500
Message-ID: <GY5kd.83497$vO1.483952@nnrp1.uunet.ca>

Are you serious?

I can't retrieve from any CLOBs larger than 32KB? That's not good. I remember reading the docs and well this is what I found:

FUNCTION DBMS_LOB.SUBSTR
    (lob_loc IN BLOB,

     amount IN INTEGER := 32767,
     offset IN INTEGER := 1)

RETURN RAW; For amount I definitely couldn't go up to 32767 bytes or anything that big. I was even told that 4000 bytes was the max which ia about right.

I think that we'll have to write a java class that just reads the record through streams.

DA Morgan wrote:
> Don Vaillancourt wrote:
>

>> Thank you.
>>
>> Will the package function that you specify, dbms_lob.substr, populate 
>> the temporary tablespace just like the substr, or is it a bit more 
>> optimized.

>
>
> Hopefully optimized but there is a far more important consideration.
>
> You won't be using SUBSTR on anything larger than 32K.
>

-- 
* Don Vaillancourt
Director of Software Development
*
*WEB IMPACT INC.*
phone: 416-815-2000 ext. 245
fax: 416-815-2001
email: donv_at_web-impact.com <mailto:donv_at_webimpact.com>
web: http://www.web-impact.com



/ This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright. If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
/

Received on Tue Nov 09 2004 - 10:09:09 CST