Re: How to improve performance on dataload process

On 09/28/2005 05:54:26 AM, Zabair Ahmed wrote:
> 9.2.0.6 on Solaris 9
>
> Am loading data into a staging database using a ETL tool (Informatica)
> and have done the following to improve the performance of the dataload
> process
>
> 1) Database in no-archive log mode
> 2) Indexes being built after the dataload
> 3) Load being done in parallel
> 4) Nologging being used
> 5) Tables not being analysed during the dataload process
>
> What else can I do to improve the performance of this load process?
>

First of all, find out how active your database is and how efficient is your tool. Are you spending time in the database or elsewhere? Your tool might be, for all described here, transferring row by row over the network, not using array interface and thus increasing the number of packets by an order of magnitude, slowing the whole thing down. Perl was infamous for doing that as it wasn't supporting array interface until very recently.

-- 
Mladen Gogala
http://www.mgogala.com


--
http://www.freelists.org/webpage/oracle-l