-
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
-
Shouldn't take more than a couple of hours with a 1G dump. Show us the import statement you used.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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.
-
What's the output of select * from v$rollstat;?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
this is my roleback segment size
USN RSSIZE
---------- ----------
0 612352
2 12761088
3 3325952
4 6715392
5 3858432
-
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
BTW, what's the box you're doing the import?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|