Re: impdp very very long ...

From: <>
Date: Mon, 14 Jul 2008 19:44:06 +0200
Message-ID: <>

On Mon, 14 Jul 2008 18:54:09 +0200, "Giganews" <> wrote:

>Hello all
>I am the happy heir of a server running Red Hat Enterprise 3 with Oracle
>10.2g. This server is used for integration purposes. Every night, the prod
>db is exported to a dump file using expdp, and then we use impdp to import
>the schemas, one after the other. The export (5GB) is done in about 30
>minutes, the import takes about 7-8 hours ! There are very few people using
>this server/this db, the machine is not overloaded at all. I tried to import
>on Sunday, when really nobody works on it, same behaviour. It would be nice
>if somebody could give me some advice where to start searching. Of course I
>already rebooted the server, no change.

The first question with any performance problem is


Sybrand Bakker
Senior Oracle DBA
Received on Mon Jul 14 2008 - 12:44:06 CDT

Original text of this message