Re: 100MB Import in 10 hours?
Date: 29 Sep 1994 17:27:56 -0500
Message-ID: <eric.780877454_at_pentagon.io.com>
jp_at_vllyoak.resun.com (Jeff Perry) 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?
>Thanks in advance.
>--
>Jeff Perry
>jp_at_vllyoak.resun.com
At first glance, yes. This is way too long. Have you looked in ~/bdump/alert* to make sure there wasn't some event that stopped the load?
Also, this is a local load, not over SQL*NET right?
Our hosts are not really comparable, but my rs/6000 takes about 40 minutes to load about 80 MB, the slow way (not direct)
Eric
- |eric_at_io.com | Eric Bodenschatz, Austin, Texas | *****