Import Taking long time

[esreddy]

Hi DB Guru's,
I got a problen in import. The dump file size is 1.2GB and number of records in each table is more than 500000. its taking 8 hours to complete the import.Can any one suggest a shortcut to reduce the time of import.

Thank you,
esreddy

[julian]

Shouldn't take more than a couple of hours with a 1G dump. Show us the import statement you used.

[esreddy]

Originally posted by julian
Shouldn't take more than a couple of hours with a 1G dump. Show us the import statement you used.

this is my import statement.

imp userid=system/manager@servicename fromuser=abc touser=xyz file=/u02/abc.dmp log=import.log buffer=100000 commit=Y

[julian]

It looks OK to me, how many RBSs do you have and how big are they? Is there any activity in the DB during the import? If you try with a bit smaller buffer?

[esreddy]

Originally posted by julian

It looks OK to me, how many RBSs do you have and how big are they? Is there any activity in the DB during the import? If you try with a bit smaller buffer?

i have four RBSs idont know the size, sorry i am new to DBA.
no other activity on DB while importing.

[julian]

What's the output of select * from v$rollstat;?

[esreddy]

this is my roleback segment size


USN RSSIZE
---------- ----------
0 612352
2 12761088
3 3325952
4 6715392
5 3858432

[julian]

Not very well size RBSs but this should not be the cause. Eight hours you said for a one G dump? Odd. Try with 3 times smaller buffer. Are all tables 'empty' before the import? Is the system well tuned?

[esreddy]

I tried with buffer=20000 ; even then it is taking 4 hrs.
in general how much time will take for 2GB Dump file, any other better import option to reduce the time?

thanks

[ales]

BTW, what's the box you're doing the import?