Oracle-L: CLOB inserts

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Thu, 07 Nov 2002 08:04:37 -0800
Message-ID: <F001.004FDD77.20021107080437@fatcity.com>

One of my developers is testing a process that reads a CLOB, modifies it, and inserts it to another table. The reading and modifying goes very quickly, but the inserts take a long time. Looking at the main Wait Events I'm seeing a lot of direct path read (lob) and direct path write (lob) which seems to imply that a lot of the delay is i/o related.

Does anyone have any suggestions to speed up the inserts? The developer has been playing around with chunk size but without any improvement.

Oracle 8.1.7.2
Solaris 2.6

Here are the main wait events from statspack. The SQL*Net message from dblink is from a different process that was running at the same time:

SQL*Net message from dblink 381,218 0 0 0 689.4
SQL*Net message to dblink 381,216 0 0 0 689.4
db file scattered read 11,034 0 0 0 20.0
direct path read (lob) 1,233 0 0 0 2.2
log file parallel write 696 0 0 0 1.3
direct path write (lob) 548 0 0 0 1.0
db file sequential read 217 0 0 0 0.4

db file parallel write                170          0           0     0
0.3
control file parallel write           161          0           0     0

0.3

Thanks,
Jay Miller
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Miller, Jay
INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 07 2002 - 10:04:37 CST