|
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 |
*** 2014-04-22 17:24:08.363 Verified Hangs in the System Root Chain Total Hang Hang Hang Inst Root #hung #hung Hang Hang Resolution ID Type Status Num Sess Sess Sess Conf Span Action ----- ---- -------- ---- ----- ----- ----- ------ ------ ------------------- 7 HANG VICSELTD 2 801 2 3 HIGH LOCAL IGNRD:InstKillNotA Hang Ignored Reason: Since instance termination is not allowed, automatic hang resolution cannot be performed. inst# SessId Ser# OSPID PrcNm Event ----- ------ ----- --------- ----- ----- 2 996 39917 6598 FG log file sync 2 801 1 13786 LGWR log file parallel write 。。。。。省略部分内容 ------------------------------------------------------------------------------- Chain 2: ------------------------------------------------------------------------------- Oracle session identified by: { instance: 1 (authorcl.authorcl1) os id: 22323 process id: 64, oracle@xhdb-server3 session id: 14 session serial #: 29257 } is waiting for 'log file sync' with wait info: { p1: 'buffer#'=0x2ab p2: 'sync scn'=0x1ed4d8be time in wait: 4 min 18 sec timeout after: never wait id: 13287 blocking: 0 sessions wait history: * time between current wait and wait #1: 0.000388 sec 1. event: 'SQL*Net message from client' time waited: 0.000486 sec wait id: 13286 p1: 'driver id'=0x54435000 p2: '#bytes'=0x1 * time between wait #1 and #2: 0.000027 sec 2. event: 'SQL*Net message to client' time waited: 0.000003 sec wait id: 13285 p1: 'driver id'=0x54435000 p2: '#bytes'=0x1 * time between wait #2 and #3: 0.001494 sec 3. event: 'SQL*Net message from client' time waited: 0.002089 sec wait id: 13284 p1: 'driver id'=0x54435000 p2: '#bytes'=0x1 } and is blocked by => Oracle session identified by: { instance: 1 (authorcl.authorcl1) os id: 27634 process id: 20, oracle@xhdb-server3 (LGWR) session id: 386 session serial #: 1 } which is waiting for 'log file parallel write' with wait info: { p1: 'files'=0x1 p2: 'blocks'=0x2 p3: 'requests'=0x1 time in wait: 4 min 32 sec -----等待了4分32秒 timeout after: never wait id: 51742574 blocking: 17 sessions ------阻塞了17个Session wait history: * time between current wait and wait #1: 0.000176 sec 1. event: 'rdbms ipc message' time waited: 0.047194 sec wait id: 51742573 p1: 'timeout'=0x22 * time between wait #1 and #2: 0.000399 sec 2. event: 'log file parallel write' time waited: 0.004006 sec wait id: 51742572 p1: 'files'=0x1 p2: 'blocks'=0x2 p3: 'requests'=0x1 * time between wait #2 and #3: 0.000318 sec 3. event: 'rdbms ipc message' time waited: 2.654606 sec wait id: 51742571 p1: 'timeout'=0x12c } Chain 2 Signature: 'log file parallel write'<='log file sync' |