Re: Performance problem when using temporary clob variables.
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Apr 2004 15:01:36 +0300
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@xxxxxxxxx>
To: <Oracle-L@xxxxxxxxxxxxx>
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@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:
