Re: Import on oracle 8i slow?!?

Is it possible your SGA is set too large? I remember Oracle recommends setting it to no larger than 1/3 of your physical memory. Your vmstat indicates quite a bit of virtual memory is used.

Yong Huang

In article <86hgdq$9eu$1_at_nnrp1.deja.com>,   wy_at_fudan.edu wrote:

> [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
> ?

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