Re: Performance problem when using temporary clob variables.

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 13 Apr 2004 15:01:36 +0300
Message-ID: <050901c4214f$125ffcb0$48f923d5@porgand>

Hi!

How were you using your temporary clobs?

Can you post a short example here, also take a 10046 trace with waits, to see what's slow, temporary lob modification or final copying to the permanent lob.

Tanel.

Original Message ----- From: "Anders Bengtsson" <anders.kj.bengtsson_at_telia.com> To: <Oracle-L_at_freelists.org> Sent: Tuesday, April 13, 2004 11:58 AM Subject: Performance problem when using temporary clob variables.

> Hi,
>
> I have created a little program for collecting data from approximately
> 15 tables in a database. I store the data in the filesystem using the
> utl_file package. It is little like xml using different keywords to get
> the position when a specific table start and so on. Then I have another
> routine that should go through the file and restore the data (normally
> to another schema). So the routine is for extracting data and than
> restore the data to another schema or another database.

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 - 06:58:14 CDT