Import on oracle 8i slow?!?

From: <wy_at_fudan.edu>
Date: Mon, 24 Jan 2000 12:26:41 GMT
Message-ID: <86hgdq$9eu$1@nnrp1.deja.com>

I have installed oracle 8i on a radhat6.1 (PIII 450 cpu 6.4G harddisk 196M memory)
Everything works well(query...) except the speed of import! It takes 1.5 hour to import a 100M dmp file which contains a table with 360000 records!
In another computer installed radhat 5.1 and oracle 8.0.5 ,it import more faster
(less than 15 minutes)
why ?
can someone help me get out the touble? Thanks a lots.
YangWang.
Below are some system parameters!
[ora8_at_server450 ora8]$ vmstat 3

   procs                      memory    swap          io
system         cpu

 r b w swpd free buff cache si so bi bo in cs us sy id
 1 0 0 37532 5340 10808 30932 0 0 3 3 152 19 1 0 99
 0 1 0 37532 4632 11148 31300 0 0 55 57 993 191 2 3 95
 1 0 0 37532 3832 11468 31780 0 0 67 59 1111 181 1 4 95
 0 1 0 37532 3144 11808 32128 0 0 55 57 1000 190 1 3 96
 1 0 0 37532 3028 11816 32244 0 0 71 58 1136 188 2 3 95
 1 0 0 37532 3068 11776 32244 0 0 59 59 1046 190 1 3 96
 1 0 0 37532 2884 11788 32412 0 0 63 57 1062 188 2 5 93
 0 1 0 37532 3028 11680 32376 0 0 60 59 1052 193 2 5 94
 0 1 0 37532 3008 11712 32364 0 0 54 59 1006 193 2 3 95
 1 0 0 37532 3096 11688 32300 0 0 55 59 1022 191 0 5 95
 0 1 0 37632 3032 11664 32488 0 33 58 66 1096 204 2 4 95
 0 1 0 37760 2984 11724 32604 0 43 66 68 1176 215 2 4 94
 1 0 0 37760 3004 11616 32692 0 0 61 61 1081 196 3 3 94
?

top result
  8:06pm up 1 day, 7:24, 2 users, load average: 1.08, 1.05, 0.94 55 processes: 54 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 2.3% user, 4.9% system, 0.0% nice, 92.7% idle Mem: 192840K av, 189736K used, 3104K free, 356588K shrd, 16272K buff

Swap: 297160K av,  38092K used, 259068K free                 30164K

cached

  PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
 1547 ora8 19 0 85532 83M 82636 D 0 5.9 44.3 2:41 oracle

 1585 ora8       9   0  1028 1028   824 R       0  1.3  0.5   0:00 top
    1 root       0   0   460  460   388 S       0  0.0  0.2   0:35 init
    2 root       0   0     0    0     0 SW      0  0.0  0.0   0:00
kflushd
    3 root       0   0     0    0     0 SW      0  0.0  0.0   0:01
kupdate
    4 root       0   0     0    0     0 SW      0  0.0  0.0   0:00 kpiod

SVRMGR> connect internal
Connected.
SVRMGR> show sga

Total System Global Area                        136945040 bytes
Fixed Size                                          64912 bytes
Variable Size                                    71270400 bytes
Database Buffers                                 65536000 bytes
Redo Buffers                                        73728 bytes

SVRMGR>
[ora8_at_server450 ora8]$ df

Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda1               861728    702892    115064  86% /
/dev/hda5              5044156   3647028   1140896  76% /disk1

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 06:26:41 CST