Full import very slow- Or hanging

[Massimo_37]

I am doing a full import of my database using the parameter file as shown below
userid=system/man buffer=1024000 file=Full.dmp show=n ignore=y grants=y indexes=y rows=y full=y commit=y ~
And the script shich starts this is
#!/bin/sh echo 'imp parfile=full_Prod.par' | batch exit 0 ~
The import has been running for 2:30 hours. If i do ps -ef|grep imp it lists
[root@$ ps -ef|grep imp root 23494 23493 41 13:14:06 ? 8:16 imp parfile=full_Prod.par
And select username,process from v$session also lists import .
Then , could import be hanging or very slow. The .dmp file is around 1G in size

Many thanks in advance ~ ~

[Volker Borowski]

Hi,

hanging on import of GBs sound like an archiver stuck to me !

Reasons for archiver Stuck:
- Archive destination(s) full
- arch process not started or died

And one thing I recently heard, but never confirmed myself: background dump dest is full (an thus not allowing the alert file to grow on logswitches).

Hope this helps
Volker

[malay boy · Accepted solution]

Hi,
This is from my experience.I used to run 1G dump on HPUX11.11 512M(Memory) and it took me around 15 hours.
It's a good idea if you specify also option log= so that you can monitor the progress.

regards
mB