Re: Import into a database takes a long time

From: Ronald <ronr_at_wxs.nl>
Date: Sun, 22 Nov 1998 15:45:50 +0100
Message-ID: <01HW.B27DE22E00106BA501BEAE20@news.wxs.nl>

On Fri, 20 Nov 1998 15:51:28 +0100, MTaylo1987 wrote (in message <19981120095128.02581.00000319_at_ng42.aol.com>):
>
> I am trying to do an import of data into a database using the standard
> import facility but it seems to take forever. What areas should I look at
> for possible performance gains.
>
> Ta
>
> Mike

Do you import data & indexes in one run ? Seperating them in two runs will dramatically improve your performance. I import a 1G expdat.dmp in 45 minutes. After that I need an other 45 minutes for index creation.

At the moment I am working on a system that exports per tablespace (each have a seperate disk) and convert the *.dmp files to loader files. That will really speed things up. I generate an index creation script for every tablespace and so will be able to generate the indexes in parallel instead of sequentially when using one expdat.dmp file as input. --
Ronald

---

mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998) http://www.maccentral.com/news/9804/migration.shtml (forward migration home)

I think so I mac ! Received on Sun Nov 22 1998 - 08:45:50 CST