awk -f ass109.awk

C:\Program Files\GnuWin32\bin>awk -f ass109.awk E:\abcd_ora_389488.trc
Ass.Awk Version 1.0.9 - Processing E:\abcd_ora_389488.trc

System State 1
~~~~~~~~~~~~~~~~
1:
2:  waiting for 'pmon timer'            wait
3:  waiting for 'DIAG idle wait'        wait
4:  waiting for 'rdbms ipc message'     wait
5:  waiting for 'rdbms ipc message'     wait
6:  waiting for 'ges remote message'    wait
7:  waiting for 'gcs remote message'    wait
8:  waiting for 'gcs remote message'    wait
9:  waiting for 'gcs remote message'    wait
10: waiting for 'gcs remote message'    wait
11: waiting for 'rdbms ipc message'     wait
12: waiting for 'rdbms ipc message'     wait
13: waiting for 'rdbms ipc message'     wait
14: waiting for 'rdbms ipc message'     wait
15: waiting for 'rdbms ipc message'     wait
16: waiting for 'smon timer'            wait
17: waiting for 'rdbms ipc message'     wait
18: waiting for 'rdbms ipc message'     wait
19: waiting for 'rdbms ipc message'     wait
20: waiting for 'rdbms ipc message'     wait
21:
22:
23: waiting for 'rdbms ipc message'     wait
24: waiting for 'SQL*Net message from client' wait
     Cmd: Select
25: for 'Streams AQ: waiting for messages in the queue' wait
26: waiting for 'SQL*Net message from client' wait
     Cmd: PL/SQL Execute
27: waiting for 'rdbms ipc message'     wait
28: waiting for 'rdbms ipc message'     wait
29: waiting for 'SQL*Net message from client' wait
30: waiting for 'Streams AQ: qmn coordinator idle wait' wait
31: waiting for 'SQL*Net message from client' wait
     Cmd: Select
32: for 'Streams AQ: waiting for time management or cleanup tasks' wait
33: waiting for 'SQL*Net message from client' wait
34: waiting for 'cursor: pin S wait on X' wait
     Cmd: Insert
35: waiting for 'SQL*Net message from client' wait
36: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
37: waiting for 'SQL*Net message from client' wait
38: waiting for 'SQL*Net message from client' wait
39: waiting for 'cursor: pin S wait on X' wait
40: waiting for 'SQL*Net message from client' wait
41: waiting for 'SQL*Net message from client' wait
42: waiting for 'SQL*Net message from client' wait
43: waiting for 'SQL*Net message from client' wait
44: waiting for 'SQL*Net message from client' wait
45: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
46: waiting for 'cursor: pin S wait on X' wait
47: waiting for 'SQL*Net message from client' wait
48: waiting for 'cursor: pin S wait on X' wait
49: waiting for 'SQL*Net message from client' wait
50: waiting for 'SQL*Net message from client' wait
51: waiting for 'SQL*Net message from client' wait
52: waiting for 'SQL*Net message from client' wait
53:
54: waiting for 'SQL*Net message from client' wait
     Cmd: Update
55: waiting for 'SQL*Net message from client' wait
56: waiting for 'SQL*Net message from client' wait
57: waiting for 'SQL*Net message from client' wait
58: waiting for 'SQL*Net message from client' wait
59: waiting for 'SQL*Net message from client' wait
60: waiting for 'SQL*Net message from client' wait
61: waiting for 'SQL*Net message from client' wait
62: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
63: waiting for 'SQL*Net message from client' wait
64: waiting for 'cursor: pin S wait on X' wait
     Cmd: Insert
65: waiting for 'SQL*Net message from client' wait
66: waiting for 'SQL*Net message from client' wait
67: waiting for 'SQL*Net message from client' wait
68: waiting for 'SQL*Net message from client' wait
69: waiting for 'SQL*Net message from client' wait
70: waiting for 'SQL*Net message from client' wait
71: waiting for 'SQL*Net message from client' wait
72: waiting for 'cursor: pin S wait on X' wait
73: waiting for 'SQL*Net message from client' wait
     Cmd: Select
74: waiting for 'SQL*Net message from client' wait
75: waiting for 'SQL*Net message from client' wait
76: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
77: waiting for 'SQL*Net message from client' wait
78: waiting for 'SQL*Net message from client' wait
79: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
80: waiting for 'SQL*Net message from client' wait
81: waiting for 'SQL*Net message from client' wait
82: waiting for 'SQL*Net message from client' wait
     Cmd: Select
83: waiting for 'SQL*Net message from client' wait
84: waiting for 'SQL*Net message from client' wait
85: waiting for 'SQL*Net message from client' wait
86: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Unknown(170)
87: waiting for 'SQL*Net message from client' wait
     Cmd: Select
88: waiting for 'Streams AQ: qmn slave idle wait' wait
89: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
90: waiting for 'cursor: pin S wait on X' wait
     Cmd: Insert
91: waiting for 'SQL*Net message from client' wait
92: waiting for 'SQL*Net message from client' wait
93: waiting for 'SQL*Net message from client' wait
94: waiting for 'SQL*Net message from client' wait
95: waiting for 'cursor: pin S wait on X' wait
96: waiting for 'cursor: pin S wait on X' wait
97: waiting for 'cursor: pin S wait on X' wait
98: waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
99: waiting for 'SQL*Net message from client' wait
100:waiting for 'SQL*Net message from client' wait
101:waiting for 'SQL*Net message from client' wait
102:waiting for 'SQL*Net message from client' wait
103:waiting for 'SQL*Net message from client' wait
104:waiting for 'SQL*Net message from client' wait
105:waiting for 'SQL*Net message from client' wait
106:waiting for 'SQL*Net message from client' wait
107:waiting for 'SQL*Net message from client' wait
108:waiting for 'SQL*Net message from client' wait
     Cmd: Insert
109:waiting for 'SQL*Net message from client' wait
110:waiting for 'SQL*Net message from client' wait
111:waiting for 'SQL*Net message from client' wait
112:waiting for 'SQL*Net message from client' wait
113:waiting for 'SQL*Net message from client' wait
114:waiting for 'cursor: pin S wait on X' wait
     Cmd: Select
115:waiting for 'SQL*Net message from client' wait
116:waiting for 'SQL*Net message from client' wait
117:waiting for 'SQL*Net message from client' wait
118:waiting for 'SQL*Net message from client' wait
119:waiting for 'SQL*Net message from client' wait
120:waiting for 'SQL*Net message from client' wait
121:waiting for 'SQL*Net message from client' wait
122:waiting for 'SQL*Net message from client' wait
123:waiting for 'SQL*Net message from client' wait
124:waiting for 'SQL*Net message from client' wait
125:waiting for 'cursor: pin S wait on X' wait
     Cmd: Select
126:waiting for 'SQL*Net message from client' wait
127:waiting for 'SQL*Net message from client' wait
128:waiting for 'SQL*Net message from client' wait
129:waiting for 'SQL*Net message from client' wait
130:waiting for 'SQL*Net message from client' wait
     Cmd: Select
131:waiting for 'SQL*Net message from client' wait
     Cmd: Select
132:waiting for 'SQL*Net message from client' wait
     Cmd: Select
133:waiting for 'SQL*Net message from client' wait
134:waiting for 'SQL*Net message from client' wait
135:waiting for 'SQL*Net message from client' wait
136:waiting for 'SQL*Net message from client' wait
137:waiting for 'SQL*Net message from client' wait
138:waiting for 'SQL*Net message from client' wait
139:waiting for 'SQL*Net message from client' wait
140:waiting for 'SQL*Net message from client' wait
141:waiting for 'SQL*Net message from client' wait
142:waiting for 'SQL*Net message from client' wait
143:waiting for 'SQL*Net message from client' wait
144:waiting for 'SQL*Net message from client' wait
145:waiting for 'SQL*Net message from client' wait
146:waiting for 'SQL*Net message from client' wait
147:waiting for 'SQL*Net message from client' wait
148:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
149:waiting for 'cursor: pin S wait on X' wait
     Cmd: Select
150:last wait for 'SQL*Net message from client'
     Cmd: Select
151:waiting for 'SQL*Net message from client' wait
152:waiting for 'SQL*Net message from client' wait
153:waiting for 'SQL*Net message from client' wait
154:waiting for 'SQL*Net message from client' wait
155:waiting for 'SQL*Net message from client' wait
156:waiting for 'SQL*Net message from client' wait
     Cmd: Select
157:waiting for 'SQL*Net message from client' wait
158:waiting for 'SQL*Net message from client' wait
159:waiting for 'SQL*Net message from client' wait
160:waiting for 'SQL*Net message from client' wait
161:waiting for 'SQL*Net message from client' wait
162:waiting for 'SQL*Net message from client' wait
     Cmd: Select
163:waiting for 'SQL*Net message from client' wait
164:waiting for 'SQL*Net message from client' wait
165:waiting for 'SQL*Net message from client' wait
166:waiting for 'SQL*Net message from client' wait
167:waiting for 'SQL*Net message from client' wait
     Cmd: Select
168:waiting for 'SQL*Net message from client' wait
169:waiting for 'SQL*Net message from client' wait
170:waiting for 'SQL*Net message from client' wait
171:waiting for 'SQL*Net message from client' wait
172:waiting for 'SQL*Net message from client' wait
173:waiting for 'SQL*Net message from client' wait
     Cmd: Select
174:waiting for 'SQL*Net message from client' wait
175:waiting for 'SQL*Net message from client' wait
176:waiting for 'SQL*Net message from client' wait
177:waiting for 'SQL*Net message from client' wait
178:waiting for 'cursor: pin S wait on X' wait
     Cmd: Select
179:waiting for 'SQL*Net message from client' wait
180:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
181:waiting for 'SQL*Net message from client' wait
182:waiting for 'SQL*Net message from client' wait
183:waiting for 'SQL*Net message from client' wait
184:waiting for 'SQL*Net message from client' wait
185:waiting for 'SQL*Net message from client' wait
186:waiting for 'SQL*Net message from client' wait
187:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
188:waiting for 'SQL*Net message from client' wait
189:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
190:waiting for 'SQL*Net message from client' wait
191:waiting for 'SQL*Net message from client' wait
192:waiting for 'SQL*Net message from client' wait
193:waiting for 'SQL*Net message from client' wait
194:waiting for 'SQL*Net message from client' wait
195:waiting for 'SQL*Net message from client' wait
196:waiting for 'SQL*Net message from client' wait
197:waiting for 'SQL*Net message from client' wait
198:waiting for 'SQL*Net message from client' wait
199:waiting for 'SQL*Net message from client' wait
200:waiting for 'SQL*Net message from client' wait
201:waiting for 'SQL*Net message from client' wait
202:waiting for 'SQL*Net message from client' wait
     Cmd: Update
203:waiting for 'SQL*Net message from client' wait
     Cmd: Select
204:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
205:waiting for 'SQL*Net message from client' wait
     Cmd: Select
206:waiting for 'SQL*Net message from client' wait
     Cmd: Update
207:waiting for 'SQL*Net message from client' wait
     Cmd: Select
208:waiting for 'SQL*Net message from client' wait
     Cmd: Select
209:waiting for 'SQL*Net message from client' wait
     Cmd: Update
210:waiting for 'SQL*Net message from client' wait
211:waiting for 'SQL*Net message from client' wait
212:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
213:waiting for 'SQL*Net message from client' wait
214:waiting for 'SQL*Net message from client' wait
215:waiting for 'SQL*Net message from client' wait
216:waiting for 'SQL*Net message from client' wait
217:waiting for 'SQL*Net message from client' wait
218:waiting for 'SQL*Net message from client' wait
219:waiting for 'SQL*Net message from client' wait
220:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
221:waiting for 'SQL*Net message from client' wait
222:waiting for 'SQL*Net message from client' wait
223:waiting for 'SQL*Net message from client' wait
224:waiting for 'cursor: pin S wait on X' wait
     Cmd: Select
225:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Select
226:waiting for 'SQL*Net message from client' wait
227:waiting for 'SQL*Net message from client' wait
228:waiting for 'cursor: pin S wait on X' wait
229:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
230:waiting for 'cursor: pin S wait on X' wait
231:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
232:waiting for 'cursor: pin S wait on X' wait
233:waiting for 'SQL*Net message from client' wait
234:waiting for 'cursor: pin S wait on X' wait
235:waiting for 'SQL*Net message from client' wait
236:waiting for 'SQL*Net message from client' wait
237:waiting for 'SQL*Net message from client' wait
238:waiting for 'SQL*Net message from client' wait
239:waiting for 'SQL*Net message from client' wait
240:waiting for 'cursor: pin S wait on X' wait
241:waiting for 'SQL*Net message from client' wait
242:waiting for 'SQL*Net message from client' wait
243:waiting for 'SQL*Net message from client' wait
244:waiting for 'SQL*Net message from client' wait
245:waiting for 'jobq slave wait'       wait
246:waiting for 'SQL*Net message from client' wait
247:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Insert
248:waiting for 'cursor: pin S wait on X' wait
249:waiting for 'SQL*Net message from client' wait
250:waiting for 'cursor: pin S wait on X' wait
251:waiting for 'SQL*Net message from client' wait
252:waiting for 'cursor: pin S wait on X' wait
     Cmd: Update
253:waiting for 'SQL*Net message from client' wait
254:waiting for 'SQL*Net message from client' wait
255:waiting for 'SQL*Net message from client' wait
256:waiting for 'library cache lock'   [LOCK: handle=70000005c1b5d08] wait
     Cmd: Update
257:waiting for 'SQL*Net message from client' wait
258:waiting for 'SQL*Net message from client' wait
259:waiting for 'SQL*Net message from client' wait
260:waiting for 'SQL*Net message from client' wait
261:waiting for 'SQL*Net message from client' wait
262:waiting for 'SQL*Net message from client' wait
263:waiting for 'SQL*Net message from client' wait
264:waiting for 'SQL*Net message from client' wait
265:waiting for 'SQL*Net message from client' wait
266:waiting for 'SQL*Net message from client' wait
267:waiting for 'SQL*Net message from client' wait
268:waiting for 'SQL*Net message from client' wait
269:waiting for 'SQL*Net message from client' wait
270:waiting for 'cursor: pin S wait on X' wait
271:waiting for 'SQL*Net message from client' wait
272:waiting for 'SQL*Net message from client' wait
273:waiting for 'SQL*Net message from client' wait
274:waiting for 'SQL*Net message from client' wait
275:waiting for 'cursor: pin S wait on X' wait
276:waiting for 'SQL*Net message from client' wait
277:waiting for 'SQL*Net message from client' wait
278:waiting for 'SQL*Net message from client' wait
279:waiting for 'SQL*Net message from client' wait
280:waiting for 'SQL*Net message from client' wait
281:
282:waiting for 'SQL*Net message from client' wait
     Cmd: Update
283:last wait for 'SQL*Net message from client'
284:waiting for 'SQL*Net message from client' wait
285:waiting for 'SQL*Net message from client' wait
286:waiting for 'SQL*Net message from client' wait
287:waiting for 'SQL*Net message from client' wait
292:
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
LOCK: handle=70000005c1b5d08   125: waiting for 'cursor: pin S wait on X'
LOCK: handle=70000005c1b5d08   150: last wait for 'SQL*Net message from client'

Object Names
~~~~~~~~~~~~
LOCK: handle=70000005c1b5d08    TABL:TEST.CA_ABCD
146299 Lines Processed.

C:\Program Files\GnuWin32\bin>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/46907/viewspace-700729/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/46907/viewspace-700729/