RE: Performance problem when using temporary clob variables.
- From: "Anders Bengtsson" <anders.kj.bengtsson@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Apr 2004 21:27:35 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jonathan Lewis
Sent: den 13 april 2004 14:42
To: oracle-l@xxxxxxxxxxxxx
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
----- Original Message -----
From: "Anders Bengtsson" <anders.kj.bengtsson@xxxxxxxxx>
To: <Oracle-L@xxxxxxxxxxxxx>
Sent: Tuesday, April 13, 2004 9:58 AM
Subject: Performance problem when using temporary clob variables.
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
