通過system state dump分析WAITED TOO LONG FOR A ROW CACHE ENQUEUE

huangxuemail發表於2015-05-02
朋友發過來一份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'

結論:由於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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章