Re: 100MB Import in 10 hours?

barry.roomberg_at_compudata.com (Barry Roomberg) writes:

> -> > 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?

Well, it's a kludge to let our planners do "what if?" analysis using un-modified third party software. By letting them play on a simulation database, the production system does not receive these "what if" changes. Once we figure out what tables they're using, will build a script to truncate and then fill them using a database link instead.

-jp

--
Jeff Perry
jp_at_vllyoak.resun.com