Re: 100MB Import in 10 hours?

From: <dhuet_at_us.oracle.com>
Date: Thu, 29 Sep 94 17:06:02 EDT
Message-ID: <36fb4q$bfa_at_dcsun4.us.oracle.com>


> -> > Using Oracle 7.0.13.1, under Unix SVr4. An import of a 100MB dump
> -> file > takes around 10 hours to complete. System is a Unisys
> -> U6000/65 with four > 100MHZ i486 processors, three SCSI buses.
> -> Database, online redo logs, and > import file are all separate
> -> drives. System had minimal workload besides > that of import.
> -> Archive mode was off.
> -> >
> -> > At first glance, does ten hours seem too long for this import???
> -> If so, > any ideas on what I'm doing wrong?
>
> You should stay away formIMP whenever possible. On O7, IMPing
> takes my system at least 3 times longer then on Oracle 6.
> Why do you NEED to imp?

I don't know what's going on here, but on an old Sequent S27 with four 382-20 processors it takes me about 5 hours to import a 200 MB dump file. Received on Thu Sep 29 1994 - 22:06:02 CET

Original text of this message