Import seems to hang

[DQuinn]

Hi all,

I am running a user level import on an 8.1.7.4 database.

Import runs fine until I reach a certain table that has 2 million records. Started it friday at noon, and was still at the same table coming to work this morning.

No error messages.
Tablespace created exactly as the source database.

Any hint on why it would be so slow??

PS: I have done this import successfully before.

Thanks

[davey23uk]

do you have a table lock?

[DQuinn]

No,

Nobody is using the database at this moment.
I'm actually recreating a test DB from production.

Thanks

[slimdave]

Maybe indexes are being built, one at a time?

[pando]

look v$session_wait

[chao_ping]

Last time when I was doing a import from 9.0.1.3 to 9.2.0.4, imp hangs.
I used event 10046 to trace that imp session in oracle and used truss to trace it in unix.
And from the trace file i found it hangs when it creating a package. I pre-create the package and choose ignore=n and imp go on without errors.

Just maybe a bug and find a work-around for it.

[pando]

your package hanged may be because of library cache lock pin :-?

[Mr.Hanky]

Got a copy of the .PAR file?

[chao_ping]

Originally posted by pando
your package hanged may be because of library cache lock pin :-?

No.
There is no wait event. 10046 shows SQL doing create or replace package, and then hangs there, no further output. Just the server process spin on the CPU. One CPU 100% busy.
It must be a bug.

9014 db on linux import to 9203 db on aix.