Re: Import on oracle 8i slow?!?

Hi !
What about your Rollback Segments ('storage next' - param) your Temporaray Tablespace (also 'storage next' - param) your init.ora - param SORT_AREA_SIZE ??

Reiner

<wy_at_fudan.edu> schrieb in im Newsbeitrag: 86hgdq$9eu$1_at_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 - 07:21:59 CST