Re: 100MB Import in 10 hours?

From: Anton Dischner <dischner_at_med.uni-muenchen.de>
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

Original text of this message