Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 11.2.0.3 RAC IO问题

Jer0n

26 积分	0 好友	5 主题

发消息

11.2.0.3 RAC IO问题

1^#

发表于 2012-5-4 15:26:25 | 查看: 8637| 回复: 11

环境: Linux5.6 x64+11.2.3 RAC
现状: GI和Oracle已经安装完毕, RDBMS实例暂未创建, CRS一旦启动, kjournald  IO就上去了, 主机响应非常慢, 未解决!

(1), 查询结果,sda2写很频繁.
[grid@vmrac4 ~]$ iostat 5
avg-cpu:  %user %nice %system %iowait  %steal %idle
         3.73 0.00 6.88 80.35 0.00 9.04

Device:          tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda          203.67    1165.33    6986.67    3496    20960
sda1             0.00       0.00       0.00       0       0
sda2          203.33    1165.33    6746.67    3496    20240
sda3             0.33       0.00    240.00       0       720
sdb             1.00       0.00       3.33       0       10
sdb1             1.00       0.00       3.33       0       10
sdc             0.00       0.00       0.00       0       0
sdc1             0.00       0.00       0.00       0       0
sdd             0.33       0.00       2.67       0       8
sdd1             0.33       0.00       2.67       0       8
sde             0.33       0.00       2.67       0       8
sde1             0.33       0.00       2.67       0       8
sdf             0.33       0.00       2.67       0       8
sdf1             0.33       0.00       2.67       0       8
sdg             0.00       0.00       0.00       0       0
sdg1             0.00       0.00       0.00       0       0

(2), 进程占用io查询, 发现kjournald一直很高.
[root@vmrac4 ~]# ./io.py
TASK                      PID    READ    WRITE
ologgerd                5922       57       85
oracle                   11048       1       0
java                      9616       176       0
oracle                   5372       0       1
kjournald                558       0       298
ocssd.bin                4861       0       0
sqlplus                10208       0       0
oracle                   11130       0       0
pdflush                11160       0       0
kjournald                558       0       316
ologgerd                5922       4       41
java                      9616       5       0
ocssd.bin                4861       0       0
kjournald                558       0       527
ologgerd                5922       28       154
java                      9616       1       0
oracle                   5372       0       3
ocssd.bin                4861       0       0
java                      9616       7       0
ocssd.bin                4861       0       0
kjournald                558       0       197
orarootagent.bi          5180       7       0
ologgerd                5922       0       20
java                      9616       3       0
kjournald                558       0       91
ologgerd                5922       2       43
ocssd.bin                4861       0       0
kjournald                558       0       385
ologgerd                5922       10       105

(3), 将CRS disable后, 主机IO正常.
这个问题你怎么看, 给点提示呢? 需要什么数据我可以贴给你.谢了!

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-5-4 15:34:13

action plan:
贴出一下命令的输出

cat /proc/meminfo
cat /proc/cpuinfo

hdparm -tT /dev/sda

cat /proc/scsi/iscsi

回复只看该作者道具举报

Jer0n

3^#

发表于 2012-5-4 15:50:17

[root@vmrac4 ~]# cat /proc/meminfo
MemTotal:    1504792 kB
MemFree:       58716 kB
Buffers:       2224 kB
Cached:       440112 kB
SwapCached:    179328 kB
Active:       1240260 kB
Inactive:       38052 kB
HighTotal:          0 kB
HighFree:          0 kB
LowTotal:    1504792 kB
LowFree:       58716 kB
SwapTotal:    3140696 kB
SwapFree:    2335164 kB
Dirty:          14696 kB
Writeback:          0 kB
AnonPages:    817736 kB
Mapped:       346520 kB
Slab:          49980 kB
PageTables:    66668 kB
NFS_Unstable:       0 kB
Bounce:             0 kB
CommitLimit: 3893092 kB
Committed_AS:  5609152 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 283180 kB
VmallocChunk: 34359453939 kB
HugePages_Total:    0
HugePages_Free:    0
HugePages_Rsvd:    0
Hugepagesize:    2048 kB

[root@vmrac4 ~]# cat /proc/cpuinfo
processor    : 0
vendor_id    : GenuineIntel
cpu family    : 6
model          : 15
model name    : Intel(R) Core(TM)2 Quad CPU Q6600  @ 2.40GHz
stepping       : 11
cpu MHz       : 2393.970
cache size    : 4096 KB
fpu          : yes
fpu_exception : yes
cpuid level    : 10
wp             : yes
flags          : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss syscall nx lm constant_tsc pni ssse3 cx16 lahf_lm
bogomips       : 4787.94
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:

processor    : 1
vendor_id    : GenuineIntel
cpu family    : 6
model          : 15
model name    : Intel(R) Core(TM)2 Quad CPU Q6600  @ 2.40GHz
stepping       : 11
cpu MHz       : 2393.970
cache size    : 4096 KB
fpu          : yes
fpu_exception : yes
cpuid level    : 10
wp             : yes
flags          : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss syscall nx lm constant_tsc pni ssse3 cx16 lahf_lm
bogomips       : 4787.94
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:

[root@vmrac4 ~]# hdparm -tT /dev/sda

/dev/sda:
Timing cached reads: 6904 MB in  2.00 seconds = 3455.26 MB/sec
Timing buffered disk reads: 6 MB in  6.17 seconds = 995.95 kB/sec

[root@vmrac4 ~]# cat /proc/scsi/iscsi
cat: /proc/scsi/iscsi: No such file or directory

[root@vmrac4 ~]# cat /proc/scsi/
device_info  mptspi/    scsi       sg/
[root@vmrac4 ~]# cat /proc/scsi/scsi
Attached devices:
Host: scsi0 Channel: 00 Id: 00 Lun: 00
  Vendor: VMware,  Model: VMware Virtual S Rev: 1.0
  Type: Direct-Access                   ANSI SCSI revision: 02
Host: scsi1 Channel: 00 Id: 00 Lun: 00
  Vendor: VMware,  Model: VMware Virtual S Rev: 1.0
  Type: Direct-Access                   ANSI SCSI revision: 02
Host: scsi1 Channel: 00 Id: 01 Lun: 00
  Vendor: VMware,  Model: VMware Virtual S Rev: 1.0
  Type: Direct-Access                   ANSI SCSI revision: 02
Host: scsi1 Channel: 00 Id: 02 Lun: 00
  Vendor: VMware,  Model: VMware Virtual S Rev: 1.0
  Type: Direct-Access                   ANSI SCSI revision: 02
Host: scsi1 Channel: 00 Id: 03 Lun: 00
  Vendor: VMware,  Model: VMware Virtual S Rev: 1.0
  Type: Direct-Access                   ANSI SCSI revision: 02
Host: scsi1 Channel: 00 Id: 04 Lun: 00
  Vendor: VMware,  Model: VMware Virtual S Rev: 1.0
  Type: Direct-Access                   ANSI SCSI revision: 02
Host: scsi1 Channel: 00 Id: 05 Lun: 00
  Vendor: VMware,  Model: VMware Virtual S Rev: 1.0
  Type: Direct-Access                   ANSI SCSI revision: 02

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2012-5-4 15:52:42

[root@vmrac4 ~]# cat /proc/meminfo
MemTotal: 1504792 kB

该虚拟主机的物理内存不超过2G ， 11gR2 RAC 推荐配置至少4g 内存，在物理内存较小的情况下会发生大量的换页SWAP ， swap本身会导致 kjournald IO

建议你提高虚拟主机的性能配置

回复只看该作者道具举报

Jer0n

5^#

发表于 2012-5-4 15:54:57

好的! 我先验证一下, 谢了!

回复只看该作者道具举报

maclean3

6^#

发表于 2012-5-5 00:06:33

PNG 图片测试

回复只看该作者道具举报

Jer0n

7^#

发表于 2012-5-8 11:10:21

Mac, 我增大内存到2GB, 完全没有好转, 没能决这个问题, 不知道是不是主机配置太低了导致的,我打算改用32位的试试看.

回复只看该作者道具举报

harryzhang

8^#

发表于 2012-5-15 16:20:13

hello，
我在我的虚拟机里面也遇到和你相同的问题。我的版本是11203
[root@db2 ~]# python io.py
TASK             PID    READ    WRITE

sh             7353       0       0

ssh             7348       4       0
kjournald       657       0       433
ologgerd       7145       0       151
oracle          5617       1       0
ocssd.bin       4645       0       0

ssh             7348       1       0
kswapd0          315       0       775
oracle          5617       0       0

kjournald       657       0       415
ocssd.bin       4645       0       0
ologgerd       7145       0       119
ssh             7348       11       0
oracle          5641       0       0
oracle          5617       1       0
pdflush       7344       0       7

vmstat 1
avg-cpu:  %user %nice %system %iowait  %steal %idle
         0.51 0.00 2.06 26.48 0.00 70.95

Device:          tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda          264.00       0.00    4224.00       0    4224
sda1             0.00       0.00       0.00       0       0
sda2          264.00       0.00    4224.00       0    4224
sdb             0.00       0.00       0.00       0       0
dm-0          716.00       0.00    5728.00       0    5728
dm-1             0.00       0.00       0.00       0       0

发现linux-64下有这样一个bug，可能相关
Bug 13867435 : OLOGGERD USING A LOT OF RESOURCES

ype B - Defect Fixed in Product Version
Severity 2 - Severe Loss of Service Product Version 11.2.0.3
Status 30 - Additional Information Requested Platform 226 - Linux x86-64
Created 21-Mar-2012 Platform Version RED HAT ENTERPRISE LINUX 5
Updated 24-Apr-2012 Base Bug N/A
Database Version 11.2.0.3 Affects Platforms Generic
Product Source Oracle

Hdr: 13867435 11.2.0.3 PCW 11.2.0.3 IPD-OS PRODID-5 PORTID-226
Abstract: OLOGGERD USING A LOT OF RESOURCES

*** 03/20/12 11:47 am ***
3-5460337991

PROBLEM:
--------
ologgerd using a lot of resources

回复只看该作者道具举报

Maclean Liu(刘相兵

9^#

发表于 2012-5-15 16:27:04

安装 11gR2 RAC host memory 至少准备 3GB ，最好是 4GB以上否则安装不成功或者安装完了系统负载很高都属于正常现象。

回复只看该作者道具举报

harryzhang

10^#

发表于 2012-5-15 16:58:42

我调整了vm的内存，设置为4.5G，下面的采集的数据，请查看。

[oracle@db2 ~]$ export ORACLE_SID=rawdb2
[oracle@db2 ~]$ sqlplus  / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 15 16:57:58 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0    Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL> show parameter cluster

NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
cluster_database                   boolean    TRUE

[root@db2 ~]# uptime
16:54:32 up 8 min,  5 users,  load average: 5.21, 3.81, 1.80
[root@db2 ~]# free -m
         total    used    free    shared buffers    cached
Mem:       4339    2835    1503       0       29    1070
-/+ buffers/cache:    1735    2604
Swap:       4095       0    4095
[root@db2 ~]# iostat 1
Linux 2.6.18-194.el5 (db2)    05/15/2012

avg-cpu:  %user %nice %system %iowait  %steal %idle
         1.14 0.00 3.72 32.45 0.00 62.69

Device:          tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda          236.70    3070.05    4162.68 1687086 2287516
sda1             0.49    381.96       0.01    209900       4
sda2          236.17    2685.67    4162.67 1475858 2287512
sdb             0.86    777.64       0.00    427336       0
dm-0          555.55    2057.40    4163.09 1130602 2287744
dm-1             0.14       1.15       0.00       632       0
sdc             0.02       0.38       0.00       209       0
sdd             0.30       0.73       1.85       402    1016
sdg             0.14       0.80       0.60       438       328
sde             2.89       37.59       4.92    20655    2702
sdf             0.70    701.01       0.00    385224       0
sdi             0.02       0.38       0.00       209       0
sdh             0.74    730.84       0.00    401616       0
sdk             0.26       4.98       0.52    2738       288
sdm             0.13       1.43       0.70       786       384
sdr             0.03       0.58       0.00       320       0
sdo             0.11       0.38       0.23       211       127
sdq             2.55       59.52       0.38    32706       208
sdl             0.05       0.64       0.09       354       48
sdj             0.05       0.62       0.09       338       48
sdp             0.77    768.10       0.00    422096       0
sdn             0.09       45.35       0.02    24921       11
sds             2.82       87.62       12.81    48152    7040

avg-cpu:  %user %nice %system %iowait  %steal %idle
         1.28 0.00 2.81 25.58 0.00 70.33

Device:          tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda          337.00       0.00    5832.00       0    5832
sda1             0.00       0.00       0.00       0       0
sda2          337.00       0.00    5832.00       0    5832
sdb             0.00       0.00       0.00       0       0
dm-0          796.00       0.00    6368.00       0    6368
dm-1             0.00       0.00       0.00       0       0
sdc             0.00       0.00       0.00       0       0
sdd             1.00       0.00       8.00       0       8
sdg             0.00       0.00       0.00       0       0
sde             2.00       0.00       9.00       0       9
sdf             0.00       0.00       0.00       0       0
sdi             0.00       0.00       0.00       0       0
sdh             0.00       0.00       0.00       0       0
sdk             0.00       0.00       0.00       0       0
sdm             0.00       0.00       0.00       0       0
sdr             0.00       0.00       0.00       0       0
sdo             0.00       0.00       0.00       0       0
sdq             0.00       0.00       0.00       0       0
sdl             0.00       0.00       0.00       0       0
sdj             0.00       0.00       0.00       0       0
sdp             0.00       0.00       0.00       0       0
sdn             0.00       0.00       0.00       0       0
sds             1.00       32.00       0.00       32       0

avg-cpu:  %user %nice %system %iowait  %steal %idle
         0.51 0.00 2.56 27.44 0.00 69.49

Device:          tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda          389.00       0.00    13856.00       0    13856
sda1             0.00       0.00       0.00       0       0
sda2          389.00       0.00    13856.00       0    13856
sdb             0.00       0.00       0.00       0       0
dm-0          1691.00       0.00    13528.00       0    13528
dm-1             0.00       0.00       0.00       0       0
sdc             0.00       0.00       0.00       0       0
sdd             0.00       0.00       0.00       0       0
sdg             0.00       0.00       0.00       0       0
sde             1.00       0.00       1.00       0       1
sdf             0.00       0.00       0.00       0       0
sdi             0.00       0.00       0.00       0       0
sdh             0.00       0.00       0.00       0       0
sdk             0.00       0.00       0.00       0       0
sdm             0.00       0.00       0.00       0       0
sdr             0.00       0.00       0.00       0       0
sdo             0.00       0.00       0.00       0       0
sdq             0.00       0.00       0.00       0       0
sdl             0.00       0.00       0.00       0       0
sdj             0.00       0.00       0.00       0       0
sdp             0.00       0.00       0.00       0       0
sdn             0.00       0.00       0.00       0       0
sds             6.00    192.00       0.00       192       0

[root@db2 ~]# python io.py
TASK             PID    READ    WRITE

oracle          5050       0       1
oracle          5782       0       0
kjournald       753       0       325
ologgerd       5861       0       100
ocssd.bin       4625       0       0

kjournald       753       0       425
ologgerd       5861       0       141
oracle          5782       0       0

oracle          5782       1       0
oracle          5804       7       1
kjournald       753       0       326
ologgerd       5861       0       111

oracle          5050       0       1
oracle          5782       0       0
kjournald       753       0       309
ologgerd       5861       0       96
[root@db2 ~]#
Tasks: 267 total, 1 running, 266 sleeping, 0 stopped, 0 zombie
Cpu(s):  0.8%us,  0.8%sy,  0.0%ni, 74.3%id, 22.9%wa,  0.0%hi,  1.3%si,  0.0%st
Mem: 4443836k total,  2890796k used,  1553040k free, 33064k buffers
Swap:  4194296k total,       0k used,  4194296k free,  1082984k cached

  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND
5842 root    RT 0  241m 142m  59m S  2.0  3.3 0:06.36 ologgerd
6878 root    15 0 12872 1236  820 R  2.0  0.0 0:00.06 top
  753 root    10  -5    0 0 0 D  1.0  0.0 0:02.94 kjournald
5261 root    15 0 1643m  25m  13m S  1.0  0.6 0:05.76 orarootagent.bi

回复只看该作者道具举报

Maclean Liu(刘相兵

11^#

发表于 2012-5-15 21:08:07

已知在11.2.0.3 上的问题：

Bug 13867435: OLOGGERD USING A LOT OF RESOURCES

Hdr: 13867435 11.2.0.3 PCW 11.2.0.3 IPD-OS PRODID-5 PORTID-226
Abstract: OLOGGERD USING A LOT OF RESOURCES

--------
ologgerd using a lot of resources

DIAGNOSTIC ANALYSIS:
--------------------
top - 04:04:58 up 3 days, 17:41,  1 user,  load average: 0.42, 0.61, 0.40
Tasks: 268 total, 1 running, 267 sleeping, 0 stopped, 0 zombie
Cpu(s):  1.7%us,  0.6%sy,  0.0%ni, 97.7%id,  0.0%wa,  0.0%hi,  0.0%si,
0.0%st
Mem:  41183316k total, 32588652k used,  8594664k free, 472988k buffers
Swap: 35291128k total,       0k used, 35291128k free, 30438636k cached

  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND

21396 root    15 0  349m  35m  14m S  2.0  0.1  40:53.66 orarootagent.bi

9942 root    RT 0  309m 144m  60m S  1.0  0.4  13:34.87 ologgerd

Bug 12746850: OLOGGERD CONSUMING HIGH SWAP

Hdr: 12746850 11.2.0.2.0 PCW 11.2.0.2.0 IPD-OS PRODID-5 PORTID-23
Abstract: OLOGGERD CONSUMING HIGH SWAP

*** 07/12/11 08:25 am ***

PROBLEM:
--------
High Swap Cosumption by ologgerd process

DIAGNOSTIC ANALYSIS:
--------------------
root@hipsxxs35:~ # prstat -u root -n 5
PID USERNAME  SIZE RSS STATE  PRI NICE    TIME  CPU PROCESS/NLWP

  5511 root    4360K 3960K sleep 60 0 0:08:23 3.0% prstat/1
27482 root    9554M 8337M sleep  159 -  13:46:01 1.1% ologgerd/10

[root@vrh1 ~]# ps -ef|grep ologger|grep -v grep
root    4617    1  0 May14 ?       00:03:06 /g01/11.2.0/grid/bin/ologgerd -M -d /g01/11.2.0/grid/crf/db/vrh1
[root@vrh1 ~]# pmap -d 4617
4617: /g01/11.2.0/grid/bin/ologgerd -M -d /g01/11.2.0/grid/crf/db/vrh1
Address          Kbytes Mode  Offset          Device Mapping
0000000000400000    84 r-x-- 0000000000000000 0fd:00000 ologgerd
0000000000514000    12 rw--- 0000000000014000 0fd:00000 ologgerd
0000000002498000 68936 rw--- 0000000000000000 000:00000 [ anon ]
00000000401dc000    4 ----- 0000000000000000 000:00000 [ anon ]
00000000401dd000 2048 rwx-- 0000000000000000 000:00000 [ anon ]
0000000040481000    4 ----- 0000000000000000 000:00000 [ anon ]
0000000040482000 1024 rwx-- 0000000000000000 000:00000 [ anon ]
0000000040f29000    4 ----- 0000000000000000 000:00000 [ anon ]
0000000040f2a000 2048 rwx-- 0000000000000000 000:00000 [ anon ]
000000004112a000    4 ----- 0000000000000000 000:00000 [ anon ]
000000004112b000 1024 rwx-- 0000000000000000 000:00000 [ anon ]
00000000412dd000    4 ----- 0000000000000000 000:00000 [ anon ]
00000000412de000 2048 rwx-- 0000000000000000 000:00000 [ anon ]
00000000416b0000    4 ----- 0000000000000000 000:00000 [ anon ]
00000000416b1000 2048 rwx-- 0000000000000000 000:00000 [ anon ]
0000003dbfe00000    112 r-x-- 0000000000000000 0fd:00000 ld-2.5.so
0000003dc001c000    4 r---- 000000000001c000 0fd:00000 ld-2.5.so
0000003dc001d000    4 rw--- 000000000001d000 0fd:00000 ld-2.5.so
0000003dc0200000 1336 r-x-- 0000000000000000 0fd:00000 libc-2.5.so
0000003dc034e000 2048 ----- 000000000014e000 0fd:00000 libc-2.5.so
0000003dc054e000    16 r---- 000000000014e000 0fd:00000 libc-2.5.so
0000003dc0552000    4 rw--- 0000000000152000 0fd:00000 libc-2.5.so
0000003dc0553000    20 rw--- 0000000000000000 000:00000 [ anon ]
0000003dc0600000    520 r-x-- 0000000000000000 0fd:00000 libm-2.5.so
0000003dc0682000 2044 ----- 0000000000082000 0fd:00000 libm-2.5.so
0000003dc0881000    4 r---- 0000000000081000 0fd:00000 libm-2.5.so
0000003dc0882000    4 rw--- 0000000000082000 0fd:00000 libm-2.5.so
0000003dc0a00000    8 r-x-- 0000000000000000 0fd:00000 libdl-2.5.so
0000003dc0a02000 2048 ----- 0000000000002000 0fd:00000 libdl-2.5.so
0000003dc0c02000    4 r---- 0000000000002000 0fd:00000 libdl-2.5.so
0000003dc0c03000    4 rw--- 0000000000003000 0fd:00000 libdl-2.5.so
0000003dc0e00000    88 r-x-- 0000000000000000 0fd:00000 libpthread-2.5.so
0000003dc0e16000 2044 ----- 0000000000016000 0fd:00000 libpthread-2.5.so
0000003dc1015000    4 r---- 0000000000015000 0fd:00000 libpthread-2.5.so
0000003dc1016000    4 rw--- 0000000000016000 0fd:00000 libpthread-2.5.so
0000003dc1017000    16 rw--- 0000000000000000 000:00000 [ anon ]
0000003dc4200000    84 r-x-- 0000000000000000 0fd:00000 libnsl-2.5.so
0000003dc4215000 2044 ----- 0000000000015000 0fd:00000 libnsl-2.5.so
0000003dc4414000    4 r---- 0000000000014000 0fd:00000 libnsl-2.5.so
0000003dc4415000    4 rw--- 0000000000015000 0fd:00000 libnsl-2.5.so
0000003dc4416000    8 rw--- 0000000000000000 000:00000 [ anon ]
0000003dd1000000    52 r-x-- 0000000000000000 0fd:00000 libgcc_s-4.1.2-20080825.so.1
0000003dd100d000 2048 ----- 000000000000d000 0fd:00000 libgcc_s-4.1.2-20080825.so.1
0000003dd120d000    4 rw--- 000000000000d000 0fd:00000 libgcc_s-4.1.2-20080825.so.1
0000003dd3000000    920 r-x-- 0000000000000000 0fd:00000 libstdc++.so.6.0.8
0000003dd30e6000 2044 ----- 00000000000e6000 0fd:00000 libstdc++.so.6.0.8
0000003dd32e5000    24 r---- 00000000000e5000 0fd:00000 libstdc++.so.6.0.8
0000003dd32eb000    12 rw--- 00000000000eb000 0fd:00000 libstdc++.so.6.0.8
0000003dd32ee000    72 rw--- 0000000000000000 000:00000 [ anon ]
00007fced4000000    544 rw--- 0000000000000000 000:00000 [ anon ]
00007fced4088000 64992 ----- 0000000000000000 000:00000 [ anon ]
00007fcedb8ee000    56 rw-s- 0000000000000000 0fd:00000 __db.006
00007fcedb8fc000 1160 rw-s- 0000000000000000 0fd:00000 __db.005
00007fcedba1e000 2112 rw-s- 0000000000000000 0fd:00000 __db.004
00007fcedbc2e000 2568 rw-s- 0000000000000000 0fd:00000 __db.003
00007fcedbeb0000    40 r-x-- 0000000000000000 0fd:00000 libnss_files-2.5.so
00007fcedbeba000 2044 ----- 000000000000a000 0fd:00000 libnss_files-2.5.so
00007fcedc0b9000    4 r---- 0000000000009000 0fd:00000 libnss_files-2.5.so
00007fcedc0ba000    4 rw--- 000000000000a000 0fd:00000 libnss_files-2.5.so
00007fcedc0da000    392 rw-s- 0000000000000000 0fd:00000 __db.002
00007fcedc13c000    40 r-x-- 0000000000000000 0fd:00000 libnque11.so
00007fcedc146000 1020 ----- 000000000000a000 0fd:00000 libnque11.so
00007fcedc245000    4 rw--- 0000000000009000 0fd:00000 libnque11.so
00007fcedc246000 4252 rw--- 0000000000000000 000:00000 [ anon ]
00007fcedc66d000    4 r-x-- 0000000000000000 0fd:00000 libaio.so.1.0.1
00007fcedc66e000 2044 ----- 0000000000001000 0fd:00000 libaio.so.1.0.1
00007fcedc86d000    4 rw--- 0000000000000000 0fd:00000 libaio.so.1.0.1
00007fcedc86e000    8 rw--- 0000000000000000 000:00000 [ anon ]
00007fcedc870000 2596 r-x-- 0000000000000000 0fd:00000 libnnz11.so
00007fcedcaf9000 1020 ----- 0000000000289000 0fd:00000 libnnz11.so
00007fcedcbf8000    264 rw--- 0000000000288000 0fd:00000 libnnz11.so
00007fcedcc3a000    8 rw--- 0000000000000000 000:00000 [ anon ]
00007fcedcc3c000    864 r-x-- 0000000000000000 0fd:00000 libskgxp11.so
00007fcedcd14000 1024 ----- 00000000000d8000 0fd:00000 libskgxp11.so
00007fcedce14000    8 rw--- 00000000000d8000 0fd:00000 libskgxp11.so
00007fcedce16000    392 r-x-- 0000000000000000 0fd:00000 libcell11.so
00007fcedce78000 1024 ----- 0000000000062000 0fd:00000 libcell11.so
00007fcedcf78000    40 rw--- 0000000000062000 0fd:00000 libcell11.so
00007fcedcf82000    8 rw--- 0000000000000000 000:00000 [ anon ]
00007fcedcf84000    652 r-x-- 0000000000000000 0fd:00000 libasmclntsh11.so
00007fcedd027000 1020 ----- 00000000000a3000 0fd:00000 libasmclntsh11.so
00007fcedd126000    84 rw--- 00000000000a2000 0fd:00000 libasmclntsh11.so
00007fcedd13b000    4 rw--- 0000000000000000 000:00000 [ anon ]
00007fcedd13c000    8 r-x-- 0000000000000000 0fd:00000 libskgxn2.so
00007fcedd13e000 1020 ----- 0000000000002000 0fd:00000 libskgxn2.so
00007fcedd23d000    4 rw--- 0000000000001000 0fd:00000 libskgxn2.so
00007fcedd23e000 38728 r-x-- 0000000000000000 0fd:00000 libclntsh.so.11.1
00007fcedf810000 2044 ----- 00000000025d2000 0fd:00000 libclntsh.so.11.1
00007fcedfa0f000 1624 rw--- 00000000025d1000 0fd:00000 libclntsh.so.11.1
00007fcedfba5000    152 rw--- 0000000000000000 000:00000 [ anon ]
00007fcedfbcb000    44 r-x-- 0000000000000000 0fd:00000 libocrutl11.so
00007fcedfbd6000 1024 ----- 000000000000b000 0fd:00000 libocrutl11.so
00007fcedfcd6000    4 rw--- 000000000000b000 0fd:00000 libocrutl11.so
00007fcedfcd7000    652 r-x-- 0000000000000000 0fd:00000 libocrb11.so
00007fcedfd7a000 1020 ----- 00000000000a3000 0fd:00000 libocrb11.so
00007fcedfe79000    8 rw--- 00000000000a2000 0fd:00000 libocrb11.so
00007fcedfe7b000    668 r-x-- 0000000000000000 0fd:00000 libocr11.so
00007fcedff22000 1024 ----- 00000000000a7000 0fd:00000 libocr11.so
00007fcee0022000    12 rw--- 00000000000a7000 0fd:00000 libocr11.so
00007fcee0025000    4 rw--- 0000000000000000 000:00000 [ anon ]
00007fcee0026000 6948 r-x-- 0000000000000000 0fd:00000 libhasgen11.so
00007fcee06ef000 1020 ----- 00000000006c9000 0fd:00000 libhasgen11.so
00007fcee07ee000    140 rw--- 00000000006c8000 0fd:00000 libhasgen11.so
00007fcee0811000    20 rw--- 0000000000000000 000:00000 [ anon ]
00007fcee0816000 1144 r-x-- 0000000000000000 0fd:00000 libdb-4.6.so
00007fcee0934000 1020 ----- 000000000011e000 0fd:00000 libdb-4.6.so
00007fcee0a33000    20 rw--- 000000000011d000 0fd:00000 libdb-4.6.so
00007fcee0a38000    4 rw--- 0000000000000000 000:00000 [ anon ]
00007fcee0a44000    24 rw-s- 0000000000000000 0fd:00000 __db.001
00007fcee0a4a000    896 r-x-- 0000000000000000 0fd:00000 libcrf11.so
00007fcee0b2a000 1024 ----- 00000000000e0000 0fd:00000 libcrf11.so
00007fcee0c2a000    20 rw--- 00000000000e0000 0fd:00000 libcrf11.so
00007fcee0c2f000    8 rw--- 0000000000000000 000:00000 [ anon ]
00007fff1f8b3000    140 rwx-- 0000000000000000 000:00000 [ stack ]
00007fff1f8f6000    4 r-x-- 0000000000000000 000:00000 [ anon ]
ffffffffff600000    4 r-x-- 0000000000000000 000:00000 [ anon ]
mapped: 247728K writeable/private: 86736K shared: 6312K

在我的系统中ologgerd 进程占用了 86M的私有内存

回复只看该作者道具举报

harryzhang

12^#

发表于 2012-5-15 22:38:50

安装11.2.0.3.1的PSU后，明显IO下降很多。

[oracle@db1 ~]$ export PATH=/u01/app/grid11203/OPatch:$PATH
[oracle@db1 ~]$ opatch  lsinventory -oh /u01/app/grid11203/
Invoking OPatch 11.2.0.1.8

Oracle Interim Patch Installer version 11.2.0.1.8
Copyright (c) 2011, Oracle Corporation.  All rights reserved.

Oracle Home    : /u01/app/grid11203
Central Inventory : /u01/app/oraInventory
from          : /etc/oraInst.loc
OPatch version : 11.2.0.1.8
OUI version    : 11.2.0.3.0
Log file location : /u01/app/grid11203/cfgtoollogs/opatch/opatch2012-05-15_22-36-57PM.log

Lsinventory Output file location : /u01/app/grid11203/cfgtoollogs/opatch/lsinv/lsinventory2012-05-15_22-36-57PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure                                        11.2.0.3.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  13343438    : applied on Tue May 15 21:43:14 CST 2012
Unique Patch ID:  14274976
Patch Description:  "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Created on 3 Jan 2012, 02:50:27 hrs PST8PDT
Bugs fixed:
   12998795, 13466801, 13492735, 12834027, 12620823, 13035804, 13362079
   12718090, 13528551, 13041324, 13343438, 12917230, 12847466, 9703627
   12797765, 12950644, 12905058, 13499128, 12861463, 9873405, 12938841

Patch  13348650    : applied on Tue May 15 21:42:22 CST 2012
Unique Patch ID:  14274976
Patch Description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.1 (13348650)"
Created on 14 Jan 2012, 08:08:00 hrs PST8PDT
Bugs fixed:
   13348650, 13039908, 12794268, 13011520, 12784559, 12758736, 13077654
   13001901, 13074261, 12971251, 12538907, 13066371, 12857064, 12897651
   12897902, 12896850, 12726222, 12829429, 12728585, 13396284, 12899169
   13079948, 13111013, 12876314, 12867511, 13090686, 12925041, 12995950
   13085732, 12848480, 12829917, 12990582, 12849377, 12934171, 12975811
   12917897, 12914824, 13082238, 13334158, 12947871, 12950823, 13355963
   12878750, 13001955, 13002015, 11836951, 12965049, 13024624, 12765467
   12791719, 12885323, 13345868, 13019958, 13255295, 12810890, 12782756
   12823042, 12825835, 12932852, 12695029, 12873909, 13263435, 13038806
   12820045, 12842804, 12827493, 13396356, 13045518, 12765868, 12834777
   13068077, 12772345, 12823838

Rac system comprising of multiple nodes
  Local node = db1
  Remote node = db2

--------------------------------------------------------------------------------

OPatch succeeded.

原来IO等待20以上，现在基本消失。

[oracle@db1 ~]$ vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r  b swpd free buff  cache si so bi bo in cs us sy id wa st
1  0 285104 135336 6048 477148 2 68 357 111  294  850  1  2 87 10  0
0  0 285104 135336 6048 477180 0 0 48    9 1074 3799  0  1 99  0  0
1  0 285104 135460 6048 477180 0 0 144 16 1086 3898  0  1 99  0  0
0  0 285104 135336 6048 477184 0 0 32    1 1113 3703  0  1 99  0  0
1  0 285096 135336 6048 477192 0 0 16    8 1055 4210  1  1 96  2  0
0  0 285096 135460 6056 477200 0 0 112 221 1082 3871  0  2 96  2  0
0  0 285096 135584 6056 477200 0 0 32    8 1036 3695  1  1 99  0  0
0  0 285076 135460 6056 477228 32 0 64    9 1025 3447  1  1 98  1  0
0  0 285068 135460 6056 477228 8 0 104 16 1067 3668  0  1 97  2  0
0  1 285064 135460 6056 477244 0 0 28    1 1071 4499  0  1 98  1  0
0  0 285056 135460 6064 477244 0 0 36 168 1129 3834  1  1 97  1  0
0  0 285056 135212 6064 477268 0 0 160 17 1077 3691  0  1 99  0  0

[root@db1 ~]# python io.py
TASK             PID    READ    WRITE

oracle          5454       4       0
oracle          5428       0       0

oracle          5428       0       0

oracle          5454       4       0
ologgerd       4883       3       0
oracle          5428       0       0

oracle          5428       0       0

oracle          5454       5       1
oracle          5428       0       0

ologgerd       4882       0       77
kjournald       659       0       181
ologgerd       4883       1       0
oracle          5428       0       0

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册