Re: 100MB Import in 10 hours?
Date: Wed, 28 Sep 1994 09:35:09 +0100
Message-ID: <dischner-2809940935090001_at_gkc12a.klch.med.uni-muenchen.de>
Hi Jeff,
for me, a rule of thumb is that my system (a IBM RS6000/550, Oracle 7.0) makes 110 operations (inserts/updates -not- deletes) per second.
So if you have ca. 200 bytes/per record you have 500000 rows. With my system this would take approx. 1,5 hours.
Did you try the fast load option of (was it SQL-loader or SQL-import ?) ?
Good luck,
Toni
In article <e4VaTc1w165w_at_vllyoak.resun.com>, jp_at_vllyoak.resun.com (Jeff Perry) wrote:
> 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
+--------------------------------------------------------------------+ | Anton Dischner, DBA and system-programmer Phone: +49 89 70953202| | Institut fuer Klinische Chemie Fax : +49 89 70958888| | Klinikum Grosshadern Home : +49 89 6254060 | | Ludwig Maximilians Universitaet Muenchen Handy: +49 172 8388880| | 81366 Muenchen | | Marchioninistr. 15 | | Germany Mail: dischner_at_med.uni-muenchen.de| +--------------------------------------------------------------------+Received on Wed Sep 28 1994 - 09:35:09 CET