What's the CACHE and LOGGING values for these LOBs (from dba_lobs view).
If you have NOCACHE LOBs, then import has to write these immediately to disk
using direct writes (and to redologs, depending on LOGGING setting). When
you have CACHE LOBs, these don't have to be written to datafiles
immediately, they can remain in buffer cache until DBWR writes them to
disks.
Btw, when using import, set your recordlength to 65535.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 7:09 PM
Hi,
I have a apps 11.0 table that we have been importing with no problem but
when we upgraded to apps 11.i the import takes 10 times as long. Upon
inspection I found two of the columns have been converted to LOBS. I
found
a few articles on metalinks that referenced the slow import of LOBS but
nothing to really fix it.
I bumped the import buffer up to 64M and that helped by about 25% but we
need more.
I would appreciate any ideas. We are running 8.1.7.4
Thanks
Craig Ward
Southern Systems Solutions, Inc.
803-817-6438
mail2web - Check your email from the web at
http://mail2web.com/ .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
