Re: design question, use of partitioned tables?

From: Tanel Poder <tanel_at_@peldik.com>
Date: Thu, 7 Aug 2003 00:39:23 +0300
Message-ID: <3f31758d_1@news.estpak.ee>

Hi!

> I already tried direct path loads a few months ago, but unfortunately I
> can't guarantee that the lob is already present (nature of the
> application). Direct load exits when I try to load many records with a
> null lob. After a few initial tests I returned to slower conventional
> path :( .

You could set your lob segments temporarily to NOLOGGING during loading, that way you'll generate less redo.
Also check your lob chunk size, if most of your millions of lobs are 4k in size for example, you will waste much space and IO bandwidth when having 8k chunk size (min chunk size is Oracle block size).

Tanel. Received on Wed Aug 06 2003 - 16:39:23 CDT