I am trying to import a database in orcle 8. My export file
size is 2.4 GB. My DB block size is 8192 . It's taking around
12 hours . There are some big indexes on a massaive table.
Still.... is there are ways to improve on this time ?
Is this 12 hours to import is something normal ?
Most importantly, have you checked the alert log if at all there are any error whil import was in progress, specifically related with temporary tablespace?
as you said indexes are big, they will need a huge sort area in temporary tablespace for the same.
Are you using temporary tablespace as LMT ?
and to build the index separately issue the below commands - if you have enough memory you can give more than 20Megs.
alter session set sort_area_size = 20000000 ;
alter session set sort_area_retain_size = 20000000 ;
In addition for large index :
Use the noLogging feature so the logging does not take place.
Use parallel degree creation to create the Index in parallel.
Make sure you give a Lot of Space on the Temp Tablespace.
Put the Temp Tablespace on a Separate Controller so that there is no contention.
Also if possible make sure this is the only session which is accesing the temp tablespace.