| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis
Sent: den 13 april 2004 14:42
To: oracle-l_at_freelists.org
Subject: Re: Performance problem when using temporary clob variables.
There's an item in the Errata pages for my book that may still be relevant (although the item was written about 8.1.7 and 9.0.1) - are your temporary lobs defined as cache or nocache.
For more details see:
http://www.jlcomp.demon.co.uk/ch_17.html#Temporary%20Lobs
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
After that I started to consider using temporary clob variables as a working area and than store the final data in a permanent clob column in the database. And I have managed to get the code working, but the performance is very, very bad.
I have read all the documents that I have found how to optimize using temporary clob-variables, and still I'm not happy about the performance.
 |
 |