- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
2#
发表于 2015-1-11 15:03:55
odm finding:
[oracle@vrh8 ~]$ awk -f ass1033.awk szyb3_mmon_2733.trc
Starting Systemstate 1
..............................................................................
...............................................................................
..............
Ass.Awk Version 1.0.33
~~~~~~~~~~~~~~~~~~~~~~
Source file : szyb3_mmon_2733.trc
System State 1 (2014-12-29 10:16:53.844)
~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~
WARNING: The following processes had a corrupted / in-flux state object tree :
Process 156: at line 176333
1: [DEAD]
2: waiting for 'pmon timer'
3: waiting for 'DIAG idle wait'
4: waiting for 'rdbms ipc message'
5: waiting for 'rdbms ipc message'
6: waiting for 'ges remote message'
7: last wait for 'gcs remote message'
8: last wait for 'gcs remote message'
9: waiting for 'rdbms ipc message'
10: waiting for 'rdbms ipc message'
11: waiting for 'rdbms ipc message'
12: waiting for 'rdbms ipc message'
13: waiting for 'enq: RO - fast object reuse'[Enq RO-0003000D-00000001]
14: waiting for 'rdbms ipc message'
15: waiting for 'rdbms ipc message'
16: last wait for 'ksdxexeotherwait' [Rcache object=c0000004fdd21218,]
17: last wait for 'rdbms ipc message'
18:
19:
20: waiting for 'rdbms ipc message'
21: waiting for 'DFS lock handle'
Cmd: Insert
22: waiting for 'DFS lock handle'
Cmd: Insert
23: waiting for 'rdbms ipc message'
24: waiting for 'rdbms ipc message'
25: waiting for 'rdbms ipc message'
26: waiting for 'Streams AQ: qmn coordinator idle wait'
27: waiting for 'SQL*Net message from client'
28: waiting for 'SQL*Net message from client'
29: waiting for 'SQL*Net message from client'
30: waiting for 'Streams AQ: waiting for time management or cleanup tasks'
31:
32: waiting for 'SQL*Net message from client'
33: waiting for 'SQL*Net message from client'
34: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
35: waiting for 'enq: TX - row lock contention'[Enq TX-00070017-008921CA]
Cmd: Call Method
36: waiting for 'SQL*Net message from client'
37: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
38: waiting for 'SQL*Net message from client'
39: waiting for 'enq: SQ - contention'
Cmd: Call Method
40: waiting for 'DFS lock handle'
Cmd: Insert
41: waiting for 'DFS lock handle'
Cmd: Insert
42: waiting for 'enq: SQ - contention'
Cmd: Call Method
43:
44: waiting for 'enq: TX - row lock contention'[Enq TX-00070017-008921CA]
Cmd: Call Method
45:
46: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
47: waiting for 'DFS lock handle'
Cmd: Insert
48: waiting for 'DFS lock handle'
Cmd: Insert
49: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
50: waiting for 'gc current request'
Cmd: Call Method
51: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
52: waiting for 'enq: TX - row lock contention'[Enq TX-00070017-008921CA]
Cmd: Call Method
53: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
54: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
55: waiting for 'DFS lock handle'
Cmd: Select
56: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
57: waiting for 'gc buffer busy'
Cmd: Call Method
58: waiting for 'SQL*Net message from client'
59: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
60: waiting for 'SQL*Net message from client'
61: waiting for 'enq: TX - row lock contention'[Enq TX-00130003-008C762F]
Cmd: Call Method
62:
63: waiting for 'enq: TX - row lock contention'[Enq TX-00070017-008921CA]
Cmd: Call Method
64: waiting for 'DFS lock handle'
Cmd: Insert
65:
66: waiting for 'DFS lock handle'
Cmd: Select
67: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
68: waiting for 'gc current request'
Cmd: Call Method
69: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
70: waiting for 'enq: SQ - contention'
Cmd: Call Method
71: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
72: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
73: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
74: waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
75: waiting for 'enq: TX - row lock contention'[Enq TX-00130003-008C762F]
Cmd: Call Method
76:
77: waiting for 'Streams AQ: qmn slave idle wait'
78: waiting for 'DFS lock handle'
Cmd: Insert
79: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
80: waiting for 'SQL*Net message from client'
81: waiting for 'SQL*Net message from client'
82:
83: waiting for 'SQL*Net message from client'
84: waiting for 'enq: SQ - contention'
Cmd: Call Method
85: waiting for 'SQL*Net message from client'
86: waiting for 'SQL*Net message from client'
87: waiting for 'enq: SQ - contention'
Cmd: Call Method
88: waiting for 'SQL*Net message from client'
Cmd: Select
89: waiting for 'enq: SQ - contention'
Cmd: Call Method
90: waiting for 'enq: RO - fast object reuse'[Enq RO-0003005A-00000001]
91: waiting for 'DFS lock handle'
Cmd: Select
92:
93: waiting for 'SQL*Net message from client'
94: waiting for 'SQL*Net message from client'
95: waiting for 'enq: SQ - contention'
Cmd: Call Method
96: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
97: waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
98: waiting for 'SQL*Net message from client'
Cmd: Select
99: waiting for 'DFS lock handle'
Cmd: Insert
100:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
101:waiting for 'SQL*Net message from client'
102:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
103:waiting for 'SQL*Net message from client'
Cmd: Select
104:waiting for 'enq: SQ - contention'
Cmd: Call Method
105:waiting for 'enq: SQ - contention'
Cmd: Call Method
106:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
107:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
108:waiting for 'enq: SQ - contention'
Cmd: Call Method
109:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
110:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
111:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
112:waiting for 'SQL*Net message from client'
113:waiting for 'SQL*Net message from client'
114:waiting for 'SQL*Net message from client'
115:waiting for 'SQL*Net message from client'
116:waiting for 'enq: SQ - contention'
Cmd: Call Method
117:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
118:waiting for 'enq: SQ - contention'
Cmd: Call Method
119:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
120:waiting for 'SQL*Net message from client'
121:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
122:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
123:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
124:waiting for 'SQL*Net message from client'
Cmd: Select
125:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
126:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
127:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
128:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
129:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
130:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
131:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
132:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
133:waiting for 'gc current request'
Cmd: PL/SQL Execute
134:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
135:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
136:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
137:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
138:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
139:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
140:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
141:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
142:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
143:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
144:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
145:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
146:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
147:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
148:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
149:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
150:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
151:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
152:waiting for 'gc buffer busy' [Buffer 0x07c26d24]
Cmd: Call Method
153:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
154:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
155:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
156:waiting for 'gc buffer busy'
Cmd: Call Method
161:waiting for 'row cache lock' [Rcache object=c0000004fdd21218,]
Cmd: Call Method
256:waiting for 'DFS lock handle'
Cmd: Insert
307:waiting for 'SQL*Net message from client'
321:
441:waiting for 'SQL*Net message from client'
446:
558:waiting for 'DFS lock handle' [DEAD]
Cmd: Select
572:
584:waiting for 'enq: SQ - contention' [DEAD]
Cmd: Call Method
623:waiting for 'enq: SQ - contention' [DEAD]
Cmd: Call Method
628:waiting for 'enq: SQ - contention' [DEAD]
Cmd: Call Method
629:waiting for 'enq: SQ - contention' [DEAD]
Cmd: Call Method
637:waiting for 'enq: SQ - contention' [DEAD]
Cmd: Call Method
656:waiting for 'DFS lock handle' [DEAD]
Cmd: Select
699:waiting for 'SQL*Net message from client'
Blockers
~~~~~~~~
Above is a list of all the processes. If they are waiting for a resource
then it will be given in square brackets. Below is a summary of the
waited upon resources, together with the holder of that resource.
Notes:
~~~~~
o A process id of '???' implies that the holder was not found in the
systemstate. (The holder may have released the resource before we
dumped the state object tree of the blocking process).
o Lines with 'Enqueue conversion' below can be ignored *unless*
other sessions are waiting on that resource too. For more, see
http://dlsunuk11.uk.oracle.com/Public/TOOLS/Ass.html#enqcnv)
Resource Holder State
Enq RO-0003000D-00000001 12: waiting for 'rdbms ipc message'
Enq RO-0003000D-00000001 13: 13: is waiting for 12: 13:
Rcache object=c0000004fdd21218, 68: waiting for 'gc current request'
Buffer 0x07c26d24 50: waiting for 'gc current request'
Enq TX-00070017-008921CA ??? Blocker
Enq TX-00130003-008C762F ??? Blocker
Enq RO-0003005A-00000001 12: waiting for 'rdbms ipc message'
Enq RO-0003005A-00000001 90: 90: is waiting for 12: 90:
Blockers According to Tracefile Wait Info:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1. This may not work for 64bit platforms. See bug 2902997 for details.
2. If the blocking process is shown as 0 then that session may no longer be
present.
3. If resources are held across code layers then sometimes the tracefile wait
info will not recognise the problem.
No blockers seen.
Object Names
~~~~~~~~~~~~
Enq RO-0003000D-00000001
Rcache object=c0000004fdd21218, cid=3(dc_rollback_segments)
Buffer 0x07c26d24
Enq TX-00070017-008921CA
Enq TX-00130003-008C762F
Enq RO-0003005A-00000001 |
|
发表于 2015-1-11 13:58:12
|
查看: 4240|
回复: 7
|手机版|Archiver|Oracle数据库数据恢复、性能优化
IP卡
狗仔卡
分享
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
