Re: 100MB Import in 10 hours?

In article <CwvAyM.ECG_at_freenet.carleton.ca> ag831_at_FreeNet.Carleton.CA (Denis Langlais) writes:
>
> 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

Did you run the import with interim commits and relatively small buffer? Sometimes if you have a lot of large tables (especially with indexes) to import, the difference with and without interim commits can be significant. Remember when inserting into a table using import, you are also writing to the rollback segment(s) in addition to the datafiles, and the more you write to rbs between commits, the longer it takes.

--
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Cost Management System .. Oracle Corporation |
|  Email: alaw_at_us.oracle.com ..... Voice: 415.506.3390 . Fax: 415.506.7299  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel