Re: Performance problem when using temporary clob variables.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 13 Apr 2004 21:22:47 +0100
Message-ID: <006101c42195$164daed0$7102a8c0@Primary>

Unless it's changed recently, I think the chunk size of a temporary lob is equal to the block size of the temporary tablespace (which has to be the default database block size).

Regards

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

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

April 2004 Iceland http://www.index.is/oracleday.php June 2004 UK - Optimising Oracle Seminar

Original Message ----- From: "Anders Bengtsson" <anders.kj.bengtsson_at_telia.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, April 13, 2004 8:27 PM Subject: RE: Performance problem when using temporary clob variables.

Hi,

I have tried lobs defined as cache and nocache. With the nocache approach performance is much slower than the cached version.

I also tried with different chunk size when I used clob-columns in a table, but with very little progress.

Is it possible to manipulate the chunk-size for temporary clob variables?

Regards

Anders Bengtsson

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Apr 13 2004 - 16:25:29 CDT