Re: impdp very very long ...
Date: Tue, 22 Jul 2008 09:34:22 +0200
I don't know WHAT it is waiting for, but I know WHO is waiting: at some point in the alert log, I get several messages MMNL absent for 1205 secs; Foregrounds taking over MMNL absent for 2856 secs; Foregrounds taking over etc.
I found on Metalink that this might be a problem with the Undo tablespace datafile definition, when max size < initial size. This was probably the case in our system: we had set Initial Size to 1024000 KB, and max size to 1000 MB. I changed max size to 2 GB and the problem seems to be fixed. Yesterday, the procedure took about 90 minutes, which is a normal duration.
<sybrandb_at_hccnet.nl> wrote in message
> On Mon, 14 Jul 2008 18:54:09 +0200, "Giganews" <chapka56_at_hotmail.com>
>>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
>>this server/this db, the machine is not overloaded at all. I tried to
>>on Sunday, when really nobody works on it, same behaviour. It would be
>>if somebody could give me some advice where to start searching. Of course
>>already rebooted the server, no change.
> The first question with any performance problem is
> WHAT IS IT WAITING FOR?
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Jul 22 2008 - 02:34:22 CDT