Re: Import on oracle 8i slow?!?

So many issues may be considered.
1. SGA size properly? What's yout get-hit ratio? 2. Do u use 'commit=y' when u do import? And did you issue 'direct=y' when do the 'export'?
3. How many is the shared memory size when u compiled Kernel? 4. The most important one is: Oracle 8i is worse and less stable than Oracle 8.0.5 EE. This is is kind of common sense. Unless you have to use new feature of 8i(such as IFS), stick with 8.0.5 EE.

In article <86hgdq$9eu$1_at_nnrp1.deja.com>,   wy_at_fudan.edu wrote:
> 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
> mor 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 13:42:25 CST