通過system state dump分析WAITED TOO LONG FOR A ROW CACHE ENQUEUE
朋友發過來一份trace檔案,讓我幫忙分析。
發生問題時系統已經hang住了好長時間,並且這個問題是經常出現。他懷疑是由於SGA設定太小所致,因為目前SGA大小還不到2G,而主機擁有100G以上的記憶體。他想讓我看看確定是不是由於SGA記憶體元件的動態擴大或收縮導致,我提出讓他提供AWR報告,但發現因為系統hang住的時間很長,AWR快照已經很久沒有生成了,並且DBA_HIST_ACTIVE_SESSION_HISTORY中也沒有內容,只有這一份trace檔案。初步檢視trace檔案也只能確定指定的幾個程式正在處於請求dc_object鎖階段,也無法確定是由於SGA動態擴大導致,但通過ASS109工具分析trace檔案卻一目瞭然,也證實了朋友的看法,的確是因為SGA動態擴充導致。
Resource Holder State
Latch received-location: ??? Blocker
Rcache object=3c0e72bc8, 361: waiting for 'SGA: allocation forcing component growth'
Rcache object=3c056f0d0, 59: waiting for 'SGA: allocation forcing component growth'
Latch received-location: ??? Blocker
Rcache object=3c0e72bc8, 361: waiting for 'SGA: allocation forcing component growth'
Rcache object=3c056f0d0, 59: waiting for 'SGA: allocation forcing component growth'
結論:由於SGA設定太小導致經常性的資料庫hang死。
Starting Systemstate 1
Ass.Awk Version 1.0.9 - Processing ipap2_ora_14643.trc
System State 1
~~~~~~~~~~~~~~~~
1:
2: waiting for 'pmon timer'
3: waiting for 'DIAG idle wait'
4: waiting for 'rdbms ipc message'
5: waiting for 'rdbms ipc message' [Latch received-location:]
6: waiting for 'ges remote message'
7: waiting for 'gcs remote message'
8: waiting for 'gcs remote message'
9: waiting for 'gcs remote message'
10: waiting for 'gcs remote message'
11: waiting for 'gcs remote message'
12: waiting for 'gcs remote message'
13: waiting for 'gcs remote message'
14: waiting for 'gcs remote message'
15: waiting for 'gcs remote message'
16: waiting for 'gcs remote message'
17: waiting for 'gcs remote message'
18: waiting for 'gcs remote message'
19: waiting for 'gcs remote message'
20: waiting for 'gcs remote message'
21: waiting for 'gcs remote message'
22: waiting for 'gcs remote message'
23: waiting for 'gcs remote message'
24: waiting for 'gcs remote message'
25: waiting for 'gcs remote message'
26: waiting for 'gcs remote message'
27: waiting for 'gcs remote message'
28: waiting for 'gcs remote message'
29: waiting for 'gcs remote message'
30: waiting for 'gcs remote message'
31: waiting for 'gcs remote message'
32: waiting for 'gcs remote message'
33: waiting for 'gcs remote message'
34: waiting for 'gcs remote message'
35: waiting for 'gcs remote message'
36: waiting for 'gcs remote message'
37: waiting for 'gcs remote message'
38: waiting for 'gcs remote message'
39: last wait for 'rdbms ipc message'
40: waiting for 'rdbms ipc message'
41: waiting for 'rdbms ipc message'
42: waiting for 'rdbms ipc message'
43: waiting for 'rdbms ipc message'
44: waiting for 'rdbms ipc message'
45: waiting for 'rdbms ipc message'
46: waiting for 'rdbms ipc message'
47: waiting for 'rdbms ipc message'
48: waiting for 'rdbms ipc message'
49: waiting for 'rdbms ipc message'
50: waiting for 'rdbms ipc message'
51: waiting for 'rdbms ipc message'
52: waiting for 'rdbms ipc message'
53: waiting for 'rdbms ipc message'
54: waiting for 'rdbms ipc message'
55: waiting for 'rdbms ipc message'
56: waiting for 'rdbms ipc message'
57: waiting for 'rdbms ipc message'
58: waiting for 'SGA: allocation forcing component growth'
59: waiting for 'SGA: allocation forcing component growth'
60: waiting for 'SGA: allocation forcing component growth'
61: waiting for 'SGA: allocation forcing component growth'
62: waiting for 'SGA: allocation forcing component growth'
63:
64:
65: waiting for 'rdbms ipc message'
66: waiting for 'cursor: pin S wait on X'
Cmd: Select
67: waiting for 'ASM background timer'
68: waiting for 'rdbms ipc message'
69: waiting for 'class slave wait'
70: waiting for 'rdbms ipc message'
71: waiting for 'rdbms ipc message'
72: waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
73: waiting for 'Streams AQ: qmn coordinator idle wait'
74: waiting for 'SQL*Net message from client'
75: waiting for 'SQL*Net message from client'
76: waiting for 'cursor: pin S wait on X'
Cmd: Select
77: waiting for 'cursor: pin S wait on X'
Cmd: Select
78: waiting for 'cursor: pin S wait on X'
Cmd: Select
79: waiting for 'cursor: pin S wait on X'
Cmd: Select
80: waiting for 'cursor: pin S wait on X'
Cmd: Select
81: waiting for 'cursor: pin S wait on X'
Cmd: Select
82: waiting for 'cursor: pin S wait on X'
Cmd: Select
83: last wait for 'cursor: pin S wait on X'
Cmd: Select
84: waiting for 'cursor: pin S wait on X'
Cmd: Select
85: waiting for 'SQL*Net message from client'
86: waiting for 'SQL*Net message from client'
87: waiting for 'cursor: pin S wait on X'
Cmd: Select
88: waiting for 'SGA: allocation forcing component growth'
Cmd: Select
89: waiting for 'SGA: allocation forcing component growth'
Cmd: Update
90: waiting for 'cursor: pin S wait on X'
Cmd: Select
91: waiting for 'cursor: pin S wait on X'
Cmd: Select
92: waiting for 'cursor: pin S wait on X'
Cmd: Select
93: waiting for 'cursor: pin S wait on X'
Cmd: Select
94: waiting for 'cursor: pin S wait on X'
Cmd: Select
95: waiting for 'cursor: pin S wait on X'
Cmd: Select
96: waiting for 'cursor: pin S wait on X'
Cmd: Select
97: waiting for 'cursor: pin S wait on X'
Cmd: Select
98: waiting for 'cursor: pin S wait on X'
Cmd: Select
99: waiting for 'cursor: pin S wait on X'
Cmd: Select
100:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
101:waiting for 'cursor: pin S wait on X'
Cmd: Select
102:waiting for 'cursor: pin S wait on X'
Cmd: Select
103:waiting for 'SQL*Net message from client'
104:waiting for 'cursor: pin S wait on X'
Cmd: Select
105:waiting for 'cursor: pin S wait on X'
Cmd: Select
106:waiting for 'cursor: pin S wait on X'
Cmd: Select
107:waiting for 'SGA: allocation forcing component growth'
108:waiting for 'cursor: pin S wait on X'
Cmd: Select
109:waiting for 'cursor: pin S wait on X'
Cmd: Select
110:waiting for 'cursor: pin S wait on X'
Cmd: Select
111:waiting for 'cursor: pin S wait on X'
Cmd: Select
112:waiting for 'SGA: allocation forcing component growth'
Cmd: Update
113:waiting for 'cursor: pin S wait on X'
Cmd: Select
114:waiting for 'cursor: pin S wait on X'
Cmd: Select
115:waiting for 'cursor: pin S wait on X'
Cmd: Select
116:last wait for 'cursor: pin S wait on X'
Cmd: Select
117:waiting for 'cursor: pin S wait on X'
Cmd: Select
118:waiting for 'cursor: pin S wait on X'
Cmd: Select
119:last wait for 'cursor: pin S wait on X'
Cmd: Select
120:waiting for 'cursor: pin S wait on X'
Cmd: Select
121:waiting for 'SQL*Net message from client'
122:waiting for 'cursor: pin S wait on X'
Cmd: Select
123:waiting for 'SQL*Net message from client'
124:waiting for 'cursor: pin S wait on X'
Cmd: Select
125:waiting for 'cursor: pin S wait on X'
Cmd: Select
126:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
127:last wait for 'cursor: pin S wait on X'
Cmd: Select
128:waiting for 'cursor: pin S wait on X'
Cmd: Select
129:waiting for 'cursor: pin S wait on X'
Cmd: Select
130:waiting for 'cursor: pin S wait on X'
Cmd: Select
131:waiting for 'cursor: pin S wait on X'
Cmd: Select
132:waiting for 'cursor: pin S wait on X'
Cmd: Select
133:waiting for 'cursor: pin S wait on X'
Cmd: Select
134:waiting for 'cursor: pin S wait on X'
Cmd: Select
135:waiting for 'cursor: pin S wait on X'
Cmd: Select
136:waiting for 'cursor: pin S wait on X'
Cmd: Select
137:waiting for 'cursor: pin S wait on X'
Cmd: Select
138:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
139:waiting for 'SQL*Net message from client'
140:waiting for 'cursor: pin S wait on X'
Cmd: Select
141:waiting for 'SQL*Net message from client'
142:waiting for 'cursor: pin S wait on X'
Cmd: Update
143:waiting for 'SGA: allocation forcing component growth'
Cmd: Update
144:waiting for 'SQL*Net message from client'
145:waiting for 'SQL*Net message from client'
146:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
147:waiting for 'SQL*Net message from client'
148:waiting for 'cursor: pin S wait on X'
Cmd: Select
149:waiting for 'cursor: pin S wait on X'
Cmd: Select
150:last wait for 'cursor: pin S wait on X'
Cmd: Select
151:waiting for 'cursor: pin S wait on X'
Cmd: Select
152:waiting for 'cursor: pin S wait on X'
Cmd: Select
153:waiting for 'cursor: pin S wait on X'
Cmd: Select
154:waiting for 'cursor: pin S wait on X'
Cmd: Select
155:for 'Streams AQ: waiting for time management or cleanup tasks'
156:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
157:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
158:waiting for 'SQL*Net message from client'
159:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
160:waiting for 'cursor: pin S wait on X'
Cmd: Select
161:waiting for 'cursor: pin S wait on X'
Cmd: Select
162:waiting for 'cursor: pin S wait on X'
Cmd: Select
163:last wait for 'cursor: pin S wait on X'
Cmd: Select
164:waiting for 'cursor: pin S wait on X'
Cmd: Select
165:waiting for 'cursor: pin S wait on X'
Cmd: Select
166:last wait for 'cursor: pin S wait on X'
Cmd: Select
167:waiting for 'cursor: pin S wait on X'
Cmd: Select
168:last wait for 'cursor: pin S wait on X'
Cmd: Select
169:waiting for 'cursor: pin S wait on X'
Cmd: Select
170:waiting for 'cursor: pin S wait on X'
Cmd: Select
171:waiting for 'cursor: pin S wait on X'
Cmd: Select
172:waiting for 'cursor: pin S wait on X'
Cmd: Select
173:waiting for 'cursor: pin S wait on X'
Cmd: Select
174:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
175:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
176:last wait for 'row cache lock' [Rcache object=3c0e72bc8,]
177:waiting for 'cursor: pin S wait on X'
Cmd: Select
178:waiting for 'cursor: pin S wait on X'
Cmd: Select
179:waiting for 'cursor: pin S wait on X'
Cmd: Select
180:waiting for 'library cache load lock'
181:waiting for 'cursor: pin S wait on X'
Cmd: Select
182:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
183:waiting for 'SQL*Net message from client'
184:waiting for 'cursor: pin S wait on X'
Cmd: Select
185:waiting for 'cursor: pin S wait on X'
Cmd: Select
186:waiting for 'cursor: pin S wait on X'
Cmd: Select
187:waiting for 'cursor: pin S wait on X'
Cmd: Select
188:waiting for 'cursor: pin S wait on X'
Cmd: Select
189:waiting for 'cursor: pin S wait on X'
Cmd: Select
190:waiting for 'cursor: pin S wait on X'
Cmd: Select
191:waiting for 'cursor: pin S wait on X'
Cmd: Select
192:waiting for 'cursor: pin S wait on X'
Cmd: Select
193:waiting for 'cursor: pin S wait on X'
Cmd: Select
194:waiting for 'cursor: pin S wait on X'
Cmd: Select
195:waiting for 'cursor: pin S wait on X'
Cmd: Select
196:waiting for 'cursor: pin S wait on X'
Cmd: Select
197:waiting for 'cursor: pin S wait on X'
Cmd: Select
198:waiting for 'SQL*Net message from client'
199:waiting for 'cursor: pin S wait on X'
Cmd: Select
200:waiting for 'cursor: pin S wait on X'
Cmd: Select
201:waiting for 'cursor: pin S wait on X'
Cmd: Select
202:waiting for 'cursor: pin S wait on X'
Cmd: Select
203:waiting for 'cursor: pin S wait on X'
Cmd: Select
204:waiting for 'cursor: pin S wait on X'
Cmd: Select
205:waiting for 'cursor: pin S wait on X'
Cmd: Select
206:waiting for 'cursor: pin S wait on X'
Cmd: Select
207:waiting for 'cursor: pin S wait on X'
Cmd: Select
208:waiting for 'cursor: pin S wait on X'
Cmd: Select
209:waiting for 'cursor: pin S wait on X'
Cmd: Select
210:waiting for 'cursor: pin S wait on X'
Cmd: Select
211:waiting for 'cursor: pin S wait on X'
Cmd: Select
212:waiting for 'cursor: pin S wait on X'
Cmd: Select
213:waiting for 'cursor: pin S wait on X'
Cmd: Select
214:last wait for 'cursor: pin S wait on X'
Cmd: Select
215:waiting for 'cursor: pin S wait on X'
Cmd: Select
216:waiting for 'cursor: pin S wait on X'
Cmd: Select
217:waiting for 'cursor: pin S wait on X'
Cmd: Select
218:waiting for 'cursor: pin S wait on X'
Cmd: Select
219:waiting for 'cursor: pin S wait on X'
Cmd: Select
220:waiting for 'cursor: pin S wait on X'
Cmd: Select
221:waiting for 'cursor: pin S wait on X'
Cmd: Select
222:waiting for 'SQL*Net message from client'
223:waiting for 'cursor: pin S wait on X'
Cmd: Select
224:waiting for 'cursor: pin S wait on X'
Cmd: Select
225:waiting for 'cursor: pin S wait on X'
Cmd: Select
226:waiting for 'cursor: pin S wait on X'
Cmd: Select
227:waiting for 'cursor: pin S wait on X'
Cmd: Select
228:waiting for 'cursor: pin S wait on X'
Cmd: Select
229:waiting for 'cursor: pin S wait on X'
Cmd: Select
230:waiting for 'SQL*Net message from client'
231:waiting for 'cursor: pin S wait on X'
Cmd: Select
232:waiting for 'cursor: pin S wait on X'
Cmd: Select
233:waiting for 'cursor: pin S wait on X'
Cmd: Select
234:waiting for 'cursor: pin S wait on X'
Cmd: Select
235:waiting for 'cursor: pin S wait on X'
Cmd: Select
236:waiting for 'cursor: pin S wait on X'
Cmd: Select
237:waiting for 'cursor: pin S wait on X'
Cmd: Select
238:waiting for 'cursor: pin S wait on X'
Cmd: Select
239:waiting for 'cursor: pin S wait on X'
Cmd: Select
240:waiting for 'cursor: pin S wait on X'
Cmd: Select
241:last wait for 'cursor: pin S wait on X'
Cmd: Select
242:waiting for 'cursor: pin S wait on X'
Cmd: Select
243:waiting for 'cursor: pin S wait on X'
Cmd: Select
244:waiting for 'cursor: pin S wait on X'
Cmd: Select
245:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
246:waiting for 'cursor: pin S wait on X'
Cmd: Select
247:waiting for 'cursor: pin S wait on X'
Cmd: Select
248:waiting for 'cursor: pin S wait on X'
Cmd: Select
249:waiting for 'cursor: pin S wait on X'
Cmd: Select
250:waiting for 'cursor: pin S wait on X'
Cmd: Select
251:waiting for 'cursor: pin S wait on X'
Cmd: Select
252:waiting for 'cursor: pin S wait on X'
Cmd: Select
253:waiting for 'cursor: pin S wait on X'
Cmd: Select
254:waiting for 'cursor: pin S wait on X'
Cmd: Select
255:waiting for 'cursor: pin S wait on X'
Cmd: Select
256:waiting for 'cursor: pin S wait on X'
Cmd: Select
257:waiting for 'cursor: pin S wait on X'
Cmd: Select
258:waiting for 'cursor: pin S wait on X'
Cmd: Select
259:waiting for 'cursor: pin S wait on X'
Cmd: Select
260:waiting for 'cursor: pin S wait on X'
Cmd: Select
261:waiting for 'cursor: pin S wait on X'
Cmd: Select
262:waiting for 'cursor: pin S wait on X'
Cmd: Select
263:waiting for 'cursor: pin S wait on X'
Cmd: Select
264:waiting for 'cursor: pin S wait on X'
Cmd: Select
265:waiting for 'cursor: pin S wait on X'
Cmd: Select
266:waiting for 'cursor: pin S wait on X'
Cmd: Select
267:waiting for 'cursor: pin S wait on X'
Cmd: Select
268:last wait for 'cursor: pin S wait on X'
Cmd: Select
269:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
270:waiting for 'SQL*Net message from client'
271:waiting for 'SQL*Net message from client'
272:waiting for 'cursor: pin S wait on X'
Cmd: Select
273:waiting for 'cursor: pin S wait on X'
Cmd: Select
274:waiting for 'cursor: pin S wait on X'
Cmd: Select
275:waiting for 'cursor: pin S wait on X'
Cmd: Select
276:waiting for 'cursor: pin S wait on X'
Cmd: Select
277:waiting for 'cursor: pin S wait on X'
Cmd: Select
278:waiting for 'SQL*Net message from client'
279:waiting for 'cursor: pin S wait on X'
Cmd: Select
280:waiting for 'SQL*Net message from client'
281:waiting for 'cursor: pin S wait on X'
Cmd: Select
282:waiting for 'cursor: pin S wait on X'
Cmd: Select
283:waiting for 'cursor: pin S wait on X'
Cmd: Select
284:waiting for 'cursor: pin S wait on X'
Cmd: Select
285:waiting for 'cursor: pin S wait on X'
Cmd: Select
286:waiting for 'SQL*Net message from client'
287:waiting for 'cursor: pin S wait on X'
Cmd: Select
288:waiting for 'cursor: pin S wait on X'
Cmd: Select
289:waiting for 'cursor: pin S wait on X'
Cmd: Select
290:last wait for 'cursor: pin S wait on X'
Cmd: Select
291:waiting for 'cursor: pin S wait on X'
Cmd: Select
292:waiting for 'cursor: pin S wait on X'
Cmd: Select
293:waiting for 'cursor: pin S wait on X'
Cmd: Select
294:waiting for 'cursor: pin S wait on X'
Cmd: Select
295:waiting for 'cursor: pin S wait on X'
Cmd: Select
296:waiting for 'cursor: pin S wait on X'
Cmd: Select
297:waiting for 'cursor: pin S wait on X'
Cmd: Select
298:waiting for 'cursor: pin S wait on X'
Cmd: Select
299:waiting for 'cursor: pin S wait on X'
Cmd: Select
300:waiting for 'cursor: pin S wait on X'
Cmd: Select
301:waiting for 'cursor: pin S wait on X'
Cmd: Select
302:waiting for 'cursor: pin S wait on X'
Cmd: Select
303:waiting for 'cursor: pin S wait on X'
Cmd: Select
304:waiting for 'cursor: pin S wait on X'
Cmd: Select
305:waiting for 'cursor: pin S wait on X'
Cmd: Select
306:waiting for 'cursor: pin S wait on X'
Cmd: Select
307:waiting for 'cursor: pin S wait on X'
Cmd: Select
308:waiting for 'cursor: pin S wait on X'
Cmd: Select
309:waiting for 'cursor: pin S wait on X'
Cmd: Select
310:waiting for 'cursor: pin S wait on X'
Cmd: Select
311:waiting for 'cursor: pin S wait on X'
Cmd: Select
312:waiting for 'cursor: pin S wait on X'
Cmd: Select
313:waiting for 'cursor: pin S wait on X'
Cmd: Select
314:waiting for 'cursor: pin S wait on X'
Cmd: Select
315:waiting for 'cursor: pin S wait on X'
Cmd: Select
316:waiting for 'cursor: pin S wait on X'
Cmd: Select
317:waiting for 'SQL*Net message from client'
318:waiting for 'cursor: pin S wait on X'
Cmd: Select
319:waiting for 'cursor: pin S wait on X'
Cmd: Select
320:waiting for 'cursor: pin S wait on X'
Cmd: Select
321:waiting for 'cursor: pin S wait on X'
Cmd: Select
322:waiting for 'cursor: pin S wait on X'
Cmd: Select
323:waiting for 'cursor: pin S wait on X'
Cmd: Select
324:waiting for 'cursor: pin S wait on X'
Cmd: Select
325:waiting for 'SQL*Net message from client'
326:last wait for 'cursor: pin S wait on X'
Cmd: Select
327:waiting for 'cursor: pin S wait on X'
Cmd: Select
328:waiting for 'cursor: pin S wait on X'
Cmd: Select
329:waiting for 'cursor: pin S wait on X'
Cmd: Select
330:waiting for 'cursor: pin S wait on X'
Cmd: Select
331:waiting for 'cursor: pin S wait on X'
Cmd: Select
332:waiting for 'cursor: pin S wait on X'
Cmd: Select
333:waiting for 'cursor: pin S wait on X'
Cmd: Select
334:waiting for 'cursor: pin S wait on X'
Cmd: Select
335:waiting for 'cursor: pin S wait on X'
Cmd: Select
336:waiting for 'cursor: pin S wait on X'
Cmd: Select
337:last wait for 'cursor: pin S wait on X'
Cmd: Select
338:waiting for 'cursor: pin S wait on X'
Cmd: Select
339:waiting for 'cursor: pin S wait on X'
Cmd: Select
340:waiting for 'cursor: pin S wait on X'
Cmd: Select
341:waiting for 'cursor: pin S wait on X'
Cmd: Select
342:waiting for 'cursor: pin S wait on X'
Cmd: Select
343:waiting for 'cursor: pin S wait on X'
Cmd: Select
344:waiting for 'cursor: pin S wait on X'
Cmd: Select
345:waiting for 'cursor: pin S wait on X'
Cmd: Select
346:waiting for 'cursor: pin S wait on X'
Cmd: Select
347:waiting for 'cursor: pin S wait on X'
Cmd: Select
348:last wait for 'cursor: pin S wait on X'
Cmd: Select
349:waiting for 'cursor: pin S wait on X'
Cmd: Select
350:waiting for 'cursor: pin S wait on X'
Cmd: Select
351:waiting for 'cursor: pin S wait on X'
Cmd: Select
352:waiting for 'cursor: pin S wait on X'
Cmd: Select
353:waiting for 'cursor: pin S wait on X'
Cmd: Select
354:waiting for 'cursor: pin S wait on X'
Cmd: Select
355:waiting for 'cursor: pin S wait on X'
Cmd: Select
356:waiting for 'cursor: pin S wait on X'
Cmd: Select
357:waiting for 'library cache load lock'
358:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
359:waiting for 'library cache load lock'
360:waiting for 'cursor: pin S wait on X'
361:waiting for 'SGA: allocation forcing component growth'
362:last wait for 'ksdxexeotherwait' [Rcache object=3c0e72bc8,]
363:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
364:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
365:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
366:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
367:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
368:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
369:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
370:waiting for 'Streams AQ: qmn slave idle wait'
371:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
372:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
373:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
374:waiting for 'SGA: allocation forcing component growth'
Cmd: Select
375:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
376:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
377:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
378:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
379:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
380:waiting for 'SGA: allocation forcing component growth'
381:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
382:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
383:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
384:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
385:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
386:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
387:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
388:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
389:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
390:waiting for 'cursor: pin S wait on X'
391:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
392:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
393:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
394:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
395:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
396:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
397:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
398:waiting for 'row cache lock' [Rcache object=3c056f0d0,]
399:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
400:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
401:waiting for 'cursor: pin S wait on X'
402:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
403:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
404:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
405:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
406:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
407:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
408:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
409:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
410:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
411:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
412:waiting for 'cursor: pin S wait on X'
413:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
414:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
415:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
416:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
417:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
418:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
419:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
420:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
421:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
422:waiting for 'cursor: pin S wait on X'
423:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
424:waiting for 'row cache lock' [Rcache object=3c0e72bc8,]
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.
Resource Holder State
Latch received-location: ??? Blocker
Rcache object=3c0e72bc8, 361: waiting for 'SGA: allocation forcing component growth'
Rcache object=3c056f0d0, 59: waiting for 'SGA: allocation forcing component growth'
Object Names
~~~~~~~~~~~~
Latch received-location: last post received-location: kjmdrms
Rcache object=3c0e72bc8,
Rcache object=3c056f0d0,
182176 Lines Processed.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26753337/viewspace-1618155/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!AIENQ
- WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!的分析AIENQ
- 故障排除:"WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! "AIENQ
- 一次WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCKAIENQ
- Metlink:Troubleshooting:WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!AIENQ
- WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! 與 dc_tablespcesAIENQ
- WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK-[ID 278316.1]AIENQ
- 翻譯metalink關於WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK文章AIENQ
- ORA-00494 enqueue [CF] held for too long故障分析處理ENQ
- 【ASK_ORACLE】Row Cache Enqueue鎖之概念篇OracleENQ
- ORA-00494: enqueue [CF] held for too long (more than 900 seconds)ENQ
- ORA-00494: enqueue [CF] held for too long (more than 900 seconds) -RACENQ
- 通過 alter system dump logfile語句dump REDO及歸檔日誌資訊示例
- Oracle 使用 ass.awk 工具檢視 system state dump 說明Oracle
- 通過dump library cache分析與學習oracle易碎解析鎖v$lock之系列十Oracle
- System State 轉儲分析案例一則
- How to Match a Row Cache Object Child Latch to its Row CacheObject
- ReactState(狀態):React通過this.state來訪問state,通過this.setState()方法來更新stateReact
- Metlink:How to Match a Row Cache Object Child Latch to its Row CacheObject
- [alter system dump學習1]alter system dump logfile
- row cache objects latch研究Object
- 通過shell解析dump生成parfile
- 通過Cache::Memcached::Fast方式AST
- 一次Row Cache Lock問題處理過程
- PLS-00172: string literal too long
- 0403-027 The parameter list is too long for AIXAI
- 等待事件之Row Cache Lock事件
- Latch: Row Cache Objects (One bug?)Object
- Too many open files in system處理
- Laravel 5.4 常見錯誤:Specified key was too longLaravel
- alter system dump datafile headerHeader
- MySQL:Specified key was too long; max key length is 767 bytesMySql
- 【故障處理】-0403-027 The parameter list is too long
- ORA-01704: string literal too long 與CLOB
- File name too long window和linux排查,解決Linux
- Error running ‘Application’Command line is too longErrorAPP
- Mysql 報Row size too large 65535解決方法MySql
- Row size too large (> 8126)解決辦法