Re: 100MB Import in 10 hours?

In a previous article, jp_at_vllyoak.resun.com (Jeff Perry) says:

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

Yes 10 hours seems too long. Check your oracle alert log. Get a good unix monitor to check out where your bottleneck is. Recheck your init.ora parameters and try to monitor Oracle using either sqldba/monitor or look directly at the v$ tables described in your DBA book Received on Thu Sep 29 1994 - 02:32:45 CET