通过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博客 ” ，链接：https://blog.itpub.net/26753337/viewspace-1618155/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Oracle Job 迁移小记
- 如何以最快方式干净的关闭数据库?
- Oracle用户密码中含有特殊字符的登录办法
- Oracel 12c Alert日志中的Creating new log segment
- 测试RMAN的backup archivelog all delete input会不会删除还未传输到备库的归档日志
- 关于数据文件autoextend on的一点记录
- 12c 新特性之大表自动缓存 Automatic Big Table Caching
- 12c 新特性之 Limiting the Size of the Program Global Area
- 11gR2 RAC+DG打PSU补丁的简要步骤
- Oracle Data Redaction实验记录
