- 最后登录
- 2017-10-17
- 在线时间
- 93 小时
- 威望
- 157
- 金钱
- 2803
- 注册时间
- 2012-5-18
- 阅读权限
- 50
- 帖子
- 98
- 精华
- 3
- 积分
- 157
- UID
- 437
|
3#
发表于 2012-6-5 10:13:03
附上该时段的RCBG进程trc,该文件的最后修改时间为17:06:46,从内容来看RCBG正常退出无挂起现象。
tbdb1_rcbg_13681.zip
(695 Bytes, 下载次数: 885)
尚存的一些疑惑
(1) Disk file operations I/O等待
- SO: 0xc888362c8, type: 4, owner: 0xc987576e8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
- proc=0xc987576e8, name=session, file=ksu.h LINE:12459, pg=0
- (session) sid: 455 ser: 60839 trans: 0xc75af15f0, creator: 0xc987576e8
- flags: (0x100041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
- flags2: (0x48008) -/DDLT2
- DID: , short-term DID:
- txn branch: (nil)
- oct: 35, prv: 0, sql: 0x9eb32f4c8, psql: 0xcd4417108, user: 0/SYS
- ksuxds FALSE at location: 0
- service name: SYS$USERS
- client details:
- O/S info: user: oracle, term: pts/3, ospid: 7396
- machine: tbdb01_zj program: sqlplus@tbdb01_zj (TNS V1-V3)
- application name: sqlplus@tbdb01_zj (TNS V1-V3), hash value=1997861317
- Current Wait Stack:
- Not in wait; last wait ended 9 min 19 sec ago
- Wait State:
- fixed_waits=0 flags=0x28 boundary=(nil)/-1
- Session Wait History:
- elapsed time of 9 min 19 sec since last wait
- 0: waited for 'Disk file operations I/O'
- FileOperation=0x5, fileno=0x1, filetype=0x1
- wait_id=27177 seq_num=27184 snap_id=1
- wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec
- wait times: max=infinite
- wait counts: calls=0 os=0
- occurred after 0.000001 sec of elapsed time
复制代码
其中
- Current Wait Stack:
- Not in wait; last wait ended 9 min 19 sec ago
复制代码
最后一次等待发生在9分19秒之前,时间大致应该是17:07:07,自此之后并无等待发生。我觉得它导致hang的可能性不高。
(2) ASM map operations
- Fri Jun 01 17:06:51 2012
- NOTE: Deferred communication with ASM instance
- NOTE: deferred map free for map id 4
复制代码
这是alert日志中最后输出的内容
然后是ASM map operation的SO
- SO: 0xbf8c8e070, type: 123, owner: 0xc987576e8, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
- proc=0xc987576e8, name=ASM map operations, file=kffm2.h LINE:380, pg=0
- transistion:0x(nil)
- busylist:[bf8c8e0d8,bf8c8e0d8]
- freelist:[cbfaa0f00,cbfaa0f78]
- KFFMOP: hash link:[cbfaa0ef0,cbfaa0ef0] sobj link:[cbfaa0e88,bf8c8e0c8]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:0
- flags:0x0000 disk:3 au:390 lock:0 proc:0x0xc987576e8
- KFFMOP: hash link:[cbfaa0e78,cbfaa0e78] sobj link:[cbfaa0e10,cbfaa0f00]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:7
- flags:0x0000 disk:2 au:393 lock:0 proc:0x0xc987576e8
- KFFMOP: hash link:[cbfaa0e00,cbfaa0e00] sobj link:[cbfaa0c30,cbfaa0e88]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:6
- flags:0x0000 disk:0 au:427 lock:0 proc:0x0xc987576e8
- KFFMOP: hash link:[cbfaa0c20,cbfaa0c20] sobj link:[cbfaa0bb8,cbfaa0e10]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:5
- flags:0x0000 disk:1 au:392 lock:0 proc:0x0xc987576e8
- ......略
- KFFMOP: hash link:[cbfaa1238,cbfaa1238] sobj link:[cbfaa10e0,cbfaa12c0]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:0
- flags:0x0000 disk:3 au:390 lock:0 proc:0x0xc987576e8
- KFFMOP: hash link:[cbfaa10d0,cbfaa10d0] sobj link:[cbfaa1068,cbfaa1248]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:4
- flags:0x0000 disk:3 au:391 lock:0 proc:0x0xc987576e8
- KFFMOP: hash link:[cbfaa1058,cbfaa1058] sobj link:[cbfaa0f78,cbfaa10e0]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:5
- flags:0x0000 disk:1 au:392 lock:0 proc:0x0xc987576e8
- KFFMOP: hash link:[cbfaa0f68,cbfaa0f68] sobj link:[bf8c8e0c8,cbfaa1068]
- map kggrp:[0x0xcbff3bad8, 0, valid] map id:2
- group:[2,-2016913365] file:[265,753976451] extent:13
- flags:0x0000 disk:1 au:394 lock:0 proc:0x0xc987576e8
复制代码
其中
file 265是控制文件Current.265.753976451
file 267是SYSAUX.267.753976401
但是对ASM map operations不是很了解无法进一步分析,也不清楚是不是它导致的hang
(3) call SO 0xc0ad8dc80
- SO: 0xc0ad8dc80, type: 3, owner: 0xc987576e8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
- proc=0xc987576e8, name=call, file=ksu.h LINE:12455, pg=0
- (call) sess: cur c888362c8, rec c7085cfa0, usr c888362c8; flg:30 fl2:1; depth:0
- svpt(xcb:(nil) sptn:0x76 uba: 0x00000000.0000.00)
- ksudlc FALSE at location: 0
- ----------------------------------------
- SO: 0xc7092a440, type: 8, owner: 0xc0ad8dc80, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
- proc=0xc987576e8, name=enqueue, file=ksq1.h LINE:365, pg=0
- (enqueue) IS-00000000-00000000 DID: 0001-005E-00084048
- lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x2
- mode: X, lock_flag: 0x10, lock: 0xc7092a498, res: 0xcd8992e60
- own: 0xc888362c8, sess: 0xc888362c8, proc: 0xc987576e8, prv: 0xcd8992e70
- ----------------------------------------
- SO: 0xc7085cfa0, type: 4, owner: 0xc0ad8dc80, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
- proc=0xc987576e8, name=session, file=ksu.h LINE:12459, pg=0
- (session) sid: 459 ser: 16449 trans: 0xc7cad5b40, creator: (nil)
- flags: (0x2) -/REC flags_idl: (0x0) -/-/-/-/-/-
- flags2: (0x0) -/-
- DID: , short-term DID:
- txn branch: (nil)
- oct: 0, prv: 0, sql: (nil), psql: 0xcbfa7baf8, user: 0/SYS
- ksuxds FALSE at location: 0
- temporary object counter: 0
- KTU Session Commit Cache Dump for IDLs:
- KTU Session Commit Cache Dump for Non-IDLs:
复制代码
递归会话0xc7085cfa0发起事务0xc7cad5b40,起始时间17:06:48,但该会话目前没有SQL在执行。这是不是也是条线索?
看来仅凭一个processstate很难完整分析出当时系统情况,不过还是谢谢刘大 |
|