Re: Performance problem when using temporary clob variables.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 13 Apr 2004 13:42:27 +0100
Message-ID: <008101c42154$c73fc070$7102a8c0@Primary>

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_at_telia.com> To: <Oracle-L_at_freelists.org> 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_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 - 07:38:53 CDT