Re: [suse-oracle] Server Hang, Program or HW?

Dear Alexei,

After I check and read your next e-mail for this case.

My Async I/O status is

oracle 10.2.0.2 :

filesystemio_options = none
disk_asynch_io=true <- don't care because i used reiserfs

linux :

# cat /proc/slabinfo | grep kio
kioctx                63     90    256   15    1 : 
tunables  120   60    8 : slabdata      6      6      0
kiocb                  0      0    128   30    1 : 
tunables  120   60    8 : slabdata      0      0      0

My conclusion that aio is running on Server but Oracle don't used it.

Is that still any problems if I used SLES9 + SP3 2.6.5-7.244-bigsmp 
with out update on kernel?
And is this case of that problems? My server hang, without any notification.

best regards,
cung




At 01:44 AM 9/3/2008, Alexei_Roudnev wrote:
>Kernel 244 had a vew aio problems, and (in addition) was not stable 
>enough for the productionm use.
>
>Upgrade to the kernel 287, or uporade the whole system to SLES9 SP4 
>and tpo the online-update kernel 312.
>
>(Dont use SLES9 SP4 with default kernel and aio).
>
>----- Original Message -----
>From: <mailto:[email protected]>cung
>To: <mailto:[email protected]>[email protected]
>Sent: Monday, September 01, 2008 1:08 AM
>Subject: [suse-oracle] Server Hang, Program or HW?
>
>Dear all,
>
>I need sugestion for my problem.
>My server installed using SLES 9 Patch 3, 2.6.5-7.244-bigsmp, Memory 
>4 GByte, Xeon Quad Core.
>Oracle Database Server 10.2.0.2.
>
>My Server for 3 days until now, always Hang, every 1,5 - 3 hours.
>Monitor blank, keyboard dan mouse not responding.
>No error log appear in alert log oracle or messages Linux.
>
>Here I copy the top and vmstat -S M 5.
>
>Thank you for your kindness,
>cung
>
>in top wait: 99%, 100%, 100%
>in vmstat bo: 0 0 18 9
>
>
>top - 14:18:41 up  2:35,  6 users,  load average: 4.39, 1.74, 0.84
>Tasks: 188 total,   1 running, 187 sleeping,   0 stopped,   0 zombie
>Cpu0  :  0.0% us,  1.0% sy,  0.0% ni,  0.0% id, 99.0% wa,  0.0% hi,  0.0% si
>Cpu1  :  0.0% us,  0.0% sy,  0.0% ni, 100.0% id,  0.0% wa,  0.0% hi,  0.0% si
>Cpu2  :  1.0% us,  0.0% sy,  0.0% ni,  0.0% id, 99.0% wa,  0.0% hi,  0.0% si
>Cpu3  :  0.0% us,  0.0% sy,  0.0% ni,  0.0% id, 100.0% wa,  0.0% hi,  0.0% si
>Mem:   4143104k total,  3991088k used,   152016k free,   103696k buffers
>Swap:  8393952k total,    71036k used,  8322916k free,  3466772k cached
>
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
>  7994 oracle    15   0  1792 1004  724 S  1.0  0.0   1:16.01 top
>10265 oracle    15   0 1400m  21m  19m S  1.0  0.5   0:00.27 oracle
>     1 root      16   0   588  244  208 S  0.0  0.0   0:05.91 init
>     2 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/0
>     3 root      34  19     0    0    0 S  0.0  0.0   0:00.01 ksoftirqd/0
>     4 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/1
>     5 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/1
>     6 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/2
>     7 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/2
>     8 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/3
>     9 root      34  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd/3
>    10 root       5 -10     0    0    0 S  0.0  0.0   0:00.45 events/0
>    11 root       5 -10     0    0    0 S  0.0  0.0   0:00.00 events/1
>    12 root       5 -10     0    0    0 S  0.0  0.0   0:00.00 events/2
>
>
>  2  1     52    148    134   3355    0    0  8942 12619 2109 10712 
> 35  4 54  7
>  2  1     52    148    121   3366    0    0  9190 10144 1752 11633 
> 29  3 65  3
>  1  0     55    149    110   3372    0    0 20309  6128 2297 10333 
> 31  4 50 15
>  3  0     57    148    113   3372    0    0  8996 16897 2166 10030 
> 29  3 55 12
>  1  2     64    148    113   3368    0    0  7898 11498 1769  9712 
> 26  3 68  3
>  2  1     66    148    112   3374    0    0 12456  4963 1830 16411 
> 30  4 58  8
>  1  0     66    149    112   3373    0    0  7154 13906 2079 19759 
> 30  4 60  6
>  1  0     66    148    111   3375    0    0  7369  9350 1869 21321 
> 26  4 64  6
>procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
>  r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs 
> us sy id wa
>  2  0     66    148    110   3375    0    0  4517  6998 1848 47302 
> 27  6 60  7
>  1  0     66    148    110   3383    0    0   109  5064 1831 81058 
> 25  8 64  3
>  2  0     66    149    110   3380    0    0   110  4549 1680 80622 
> 23  8 66  2
>  2  0     66    148    110   3386    0    0   113  3326 1560 106683 
> 22  9 67  3
>  1  1     66    148    110   3386    0    0     2  3042 1170 96202 
> 24  9 67  0
>  3  0     67    148    109   3388    0    0  9398  1696 1862 14269 
> 26  3 67  4
>  1  3     68    148    109   3382    0    0  9194 12387 1663 13343 
> 27  3 35 35
>  1  4     68    149    108   3386    0    0  9227    42 1201 12562 
> 29  4 16 51
>  1  5     68    148    107   3388    0    0  9226    18 1143 12297 
> 26  3 41 31
>  2  5     68    148    105   3388    0    0  9328     0 1143 12513 
> 27  3 27 43
>  1  5     69    148    104   3388    0    0  9329     0 1142 13124 
> 27  3 18 51
>  3  5     69    148    101   3386    0    0 23138    18 1303 13582 
> 29  4 24 43
>  1  9     69    148    101   3385    0    0  2870     9 1073  4620 
> 10  1 38 51
>
>
>----------
>_______________________________________________
>suse-oracle mailing list
>[email protected]
>http://listx.novell.com/mailman/listinfo/suse-oracle

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle