Re: Poor performance importing LOBS

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" <ORACLE-L_at_fatcity.com> 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: cward_at_oraclexperts.com
> INET: cward_at_oraclexperts.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).