这篇文章主要介绍“Oracle systemstate使用方法有哪些”，在日常操作中，相信很多人在Oracle systemstate使用方法有哪些问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Oracle systemstate使用方法有哪些”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！
Oracle推荐的使用systemstate事件的几种情况是：
-数据库hang住了
-数据库很慢
-进程正在hang
-数据库出现某些错误
-资源争用
1.命令
计算
安全
数据库
网络和加速
企业服务
sqlplus -prelim / as sysdba
(1).单实例
SQL>oradebug setmypid
SQL>oradebug unlimit
SQL>oradebug dump systemstate 258
等1~2分钟
SQL>oradebug dump systemstate 258
等1~2分钟
SQL>oradebug dump systemstate 258
(2).RAC
SQL>oradebug setmypid
SQL>oradebug unlimit
SQL>oradebug -g all dump systemstate 258 <==-g all 表示针对所有实例生成dump
等1~2分钟
SQL>oradebug -g all dump systemstate 258
等1~2分钟
SQL>oradebug -g all dump systemstate 2582.使用ass109.awk解析trace文件
$ awk -f /oracle/ORA10/10.2.0/ass109.awk ora10_ora_22855.trc
Starting Systemstate 1
..............................................................................
...............................................................................
...............................................................................
............................................
Starting Systemstate 2
..............................................................................
...............................................................................
...............................................................................
..............................................
Ass.Awk Version 1.0.9 - Processing ora10_ora_22855.trc
System State 1
~~~~~~~~~~~~~~~~
1:
2: waiting for 'pmon timer'
3: waiting for 'rdbms ipc message'
4: waiting for 'rdbms ipc message'
5: waiting for 'rdbms ipc message'
6: waiting for 'rdbms ipc message'
7: waiting for 'control file parallel write'
8: waiting for 'smon timer'
9: waiting for 'rdbms ipc message'
10: waiting for 'rdbms ipc message'
11: waiting for 'rdbms ipc message'
12: waiting for 'rdbms ipc message'
13:
14:
15: waiting for 'SQL*Net message from client'
16: waiting for 'rdbms ipc message'
17: waiting for 'rdbms ipc message'
18: waiting for 'rdbms ipc message'
19: waiting for 'Streams AQ: qmn coordinator idle wait'
20: waiting for 'SQL*Net message from client'
21: waiting for 'SQL*Net message from client'
22: waiting for 'SQL*Net message from client'
23: waiting for 'SQL*Net message from client'
24: waiting for 'SQL*Net message from client'
25: for 'Streams AQ: waiting for time management or cleanup tasks'
26: waiting for 'SQL*Net message from client'
27: waiting for 'SQL*Net message from client'
28: waiting for 'SQL*Net message from client'
29: waiting for 'SQL*Net message from client'
30: waiting for 'SQL*Net message from client'
31: waiting for 'Streams AQ: qmn slave idle wait'
32: waiting for 'SQL*Net message from client'
33: waiting for 'SQL*Net message from client'
34: waiting for 'SQL*Net message from client'
35: waiting for 'SQL*Net message from client'
36: waiting for 'SQL*Net message from client'
37: waiting for 'SQL*Net message from client'
38: waiting for 'SQL*Net message from client'
39: waiting for 'SQL*Net message from client'
40: waiting for 'SQL*Net message from client'
41: waiting for 'SQL*Net message from client'
42: waiting for 'SQL*Net message from client'
43: waiting for 'SQL*Net message from client'
44: waiting for 'SQL*Net message from client'
45: waiting for 'SQL*Net message from client'
46: waiting for 'SQL*Net message from client'
47: waiting for 'SQL*Net message from client'
48: waiting for 'SQL*Net message from client'
49: waiting for 'SQL*Net message from client'
50: waiting for 'SQL*Net message from client'
51: waiting for 'SQL*Net message from client'
52: waiting for 'SQL*Net message from client'
53: waiting for 'SQL*Net message from client'
54: waiting for 'SQL*Net message from client'
55: waiting for 'SQL*Net message from client'
56: waiting for 'SQL*Net message from client'
57: waiting for 'SQL*Net message from client'
58: waiting for 'SQL*Net message from client'
59: waiting for 'SQL*Net message from client'
60: waiting for 'SQL*Net message from client'
61: waiting for 'SQL*Net message from client'
62: waiting for 'SQL*Net message from client'
63: waiting for 'SQL*Net message from client'
64: waiting for 'SQL*Net message from client'
65: waiting for 'SQL*Net message from client'
66: waiting for 'SQL*Net message from client'
67: waiting for 'SQL*Net message from client'
68: waiting for 'SQL*Net message from client'
69: waiting for 'SQL*Net message from client'
70: waiting for 'SQL*Net message from client'
71: waiting for 'SQL*Net message from client'
72: waiting for 'SQL*Net message from client'
73: waiting for 'SQL*Net message from client'
74: waiting for 'SQL*Net message from client'
75: waiting for 'SQL*Net message from client'
76: waiting for 'SQL*Net message from client'
77: waiting for 'SQL*Net message from client'
78: waiting for 'SQL*Net message from client'
79: waiting for 'SQL*Net message from client'
80: waiting for 'SQL*Net message from client'
81: waiting for 'SQL*Net message from client'
82: waiting for 'SQL*Net message from client'
83: waiting for 'SQL*Net message from client'
84: waiting for 'SQL*Net message from client'
85: waiting for 'SQL*Net message from client'
86: waiting for 'SQL*Net message from client'
87: waiting for 'SQL*Net message from client'
88: waiting for 'SQL*Net message from client'
89: waiting for 'SQL*Net message from client'
90: waiting for 'SQL*Net message from client'
91: waiting for 'SQL*Net message from client'
92: waiting for 'SQL*Net message from client'
93: waiting for 'SQL*Net message from client'
94: waiting for 'SQL*Net message from client'
95: waiting for 'SQL*Net message from client'
96: waiting for 'SQL*Net message from client'
97: waiting for 'SQL*Net message from client'
98: waiting for 'SQL*Net message from client'
99: waiting for 'SQL*Net message from client'
100:waiting for 'SQL*Net message from client'
101:waiting for 'SQL*Net message from client'
102:waiting for 'SQL*Net message from client'
103:waiting for 'SQL*Net message from client'
104:waiting for 'SQL*Net message from client'
105:waiting for 'SQL*Net message from client'
106:waiting for 'SQL*Net message from client'
107:waiting for 'SQL*Net message from client'
108:waiting for 'SQL*Net message from client'
109:waiting for 'SQL*Net message from client'
110:waiting for 'SQL*Net message from client'
111:waiting for 'SQL*Net message from client'
112:waiting for 'SQL*Net message from client'
113:waiting for 'SQL*Net message from client'
114:waiting for 'SQL*Net message from client'
115:waiting for 'SQL*Net message from client'
116:waiting for 'SQL*Net message from client'
117:waiting for 'SQL*Net message from client'
118:waiting for 'SQL*Net message from client'
119:waiting for 'SQL*Net message from client'
120:waiting for 'SQL*Net message from client'
121:waiting for 'SQL*Net message from client'
122:waiting for 'SQL*Net message from client'
123:waiting for 'SQL*Net message from client'
124:waiting for 'SQL*Net message from client'
125:waiting for 'SQL*Net message from client'
126:waiting for 'SQL*Net message from client'
127:waiting for 'SQL*Net message from client'
128:waiting for 'SQL*Net message from client'
129:waiting for 'SQL*Net message from client'
130:waiting for 'SQL*Net message from client'
131:waiting for 'SQL*Net message from client'
132:waiting for 'SQL*Net message from client'
133:waiting for 'SQL*Net message from client'
134:waiting for 'SQL*Net message from client'
135:waiting for 'SQL*Net message from client'
136:waiting for 'SQL*Net message from client'
137:waiting for 'SQL*Net message from client'
138:waiting for 'SQL*Net message from client'
139:waiting for 'SQL*Net message from client'
140:waiting for 'SQL*Net message from client'
141:waiting for 'SQL*Net message from client'
142:waiting for 'SQL*Net message from client'
143:waiting for 'SQL*Net message from client'
144:waiting for 'SQL*Net message from client'
145:waiting for 'SQL*Net message from client'
146:waiting for 'SQL*Net message from client'
147:waiting for 'SQL*Net message from client'
148:waiting for 'SQL*Net message from client'
149:waiting for 'SQL*Net message from client'
150:waiting for 'SQL*Net message from client'
151:waiting for 'SQL*Net message from client'
152:waiting for 'SQL*Net message from client'
153:waiting for 'SQL*Net message from client'
154:waiting for 'SQL*Net message from client'
155:waiting for 'SQL*Net message from client'
156:waiting for 'SQL*Net message from client'
157:waiting for 'SQL*Net message from client'
158:waiting for 'SQL*Net message from client'
159:waiting for 'SQL*Net message from client'
160:waiting for 'SQL*Net message from client'
161:waiting for 'SQL*Net message from client'
162:waiting for 'SQL*Net message from client'
163:waiting for 'SQL*Net message from client'
164:waiting for 'SQL*Net message from client'
165:waiting for 'SQL*Net message from client'
166:waiting for 'SQL*Net message from client'
167:waiting for 'SQL*Net message from client'
168:waiting for 'SQL*Net message from client'
169:waiting for 'SQL*Net message from client'
170:waiting for 'SQL*Net message from client'
171:waiting for 'SQL*Net message from client'
172:waiting for 'SQL*Net message from client'
173:waiting for 'SQL*Net message from client'
174:waiting for 'SQL*Net message from client'
175:waiting for 'SQL*Net message from client'
176:waiting for 'SQL*Net message from client'
177:waiting for 'SQL*Net message from client'
178:waiting for 'SQL*Net message from client'
179:waiting for 'SQL*Net message from client'
180:waiting for 'SQL*Net message from client'
181:waiting for 'SQL*Net message from client'
182:waiting for 'SQL*Net message from client'
183:waiting for 'SQL*Net message from client'
184:waiting for 'SQL*Net message from client'
185:waiting for 'SQL*Net message from client'
186:waiting for 'SQL*Net message from client'
187:waiting for 'SQL*Net message from client'
188:waiting for 'SQL*Net message from client'
189:waiting for 'SQL*Net message from client'
190:waiting for 'SQL*Net message from client'
191:waiting for 'SQL*Net message from client'
192:waiting for 'SQL*Net message from client'
193:waiting for 'SQL*Net message from client'
194:waiting for 'SQL*Net message from client'
195:waiting for 'SQL*Net message from client'
196:waiting for 'SQL*Net message from client'
197:waiting for 'SQL*Net message from client'
198:waiting for 'SQL*Net message from client'
199:waiting for 'SQL*Net message from client'
200:waiting for 'SQL*Net message from client'
201:waiting for 'SQL*Net message from client'
202:waiting for 'SQL*Net message from client'
203:waiting for 'SQL*Net message from client'
204:waiting for 'SQL*Net message from client'
205:waiting for 'SQL*Net message from client'
206:waiting for 'SQL*Net message from client'
207:waiting for 'SQL*Net message from client'
208:waiting for 'SQL*Net message from client'
209:waiting for 'SQL*Net message from client'
210:waiting for 'SQL*Net message from client'
211:waiting for 'SQL*Net message from client'
212:waiting for 'SQL*Net message from client'
213:waiting for 'SQL*Net message from client'
214:waiting for 'SQL*Net message from client'
215:waiting for 'SQL*Net message from client'
216:waiting for 'SQL*Net message from client'
217:waiting for 'SQL*Net message from client'
218:waiting for 'SQL*Net message from client'
219:waiting for 'SQL*Net message from client'
220:waiting for 'SQL*Net message from client'
221:waiting for 'SQL*Net message from client'
222:waiting for 'SQL*Net message from client'
223:waiting for 'SQL*Net message from client'
224:waiting for 'SQL*Net message from client'
225:waiting for 'enq: TX - row lock contention'[Enqueue TX-00030017-0007166A]
Cmd: Update
226:waiting for 'SQL*Net message from client'
227:waiting for 'SQL*Net message from client'
228:waiting for 'SQL*Net message from client'
229:waiting for 'SQL*Net message from client'
230:waiting for 'SQL*Net message from client'
231:waiting for 'SQL*Net message from client'
232:waiting for 'SQL*Net message from client'
233:waiting for 'SQL*Net message from client'
234:waiting for 'SQL*Net message from client'
235:waiting for 'SQL*Net message from client'
236:waiting for 'SQL*Net message from client'
237:waiting for 'SQL*Net message from client'
238:waiting for 'SQL*Net message from client'
239:waiting for 'SQL*Net message from client'
240:waiting for 'SQL*Net message from client'
241:waiting for 'SQL*Net message from client'
242:waiting for 'SQL*Net message from client'
243:waiting for 'SQL*Net message from client'
244:waiting for 'SQL*Net message from client'
245:waiting for 'SQL*Net message from client'
246:waiting for 'SQL*Net message from client'
247:waiting for 'SQL*Net message from client'
248:waiting for 'enq: TX - row lock contention'[Enqueue TX-00030017-0007166A]
Cmd: Update
249:waiting for 'SQL*Net message from client'
250:waiting for 'SQL*Net message from client'
251:last wait for 'ksdxexeotherwait'
252:waiting for 'SQL*Net message from client'
253:waiting for 'SQL*Net message from client'
254:waiting for 'SQL*Net message from client'
255:waiting for 'SQL*Net message from client'
256:waiting for 'SQL*Net message from client'
257:waiting for 'SQL*Net message from client'
258:waiting for 'SQL*Net message from client'
259:waiting for 'SQL*Net message from client'
260:waiting for 'SQL*Net message from client'
261:waiting for 'SQL*Net message from client'
262:waiting for 'SQL*Net message from client'
263:waiting for 'SQL*Net message from client'
264:waiting for 'SQL*Net message from client'
265:waiting for 'jobq slave wait'
266:waiting for 'jobq slave wait'
272:waiting for 'SQL*Net message from client'
274:waiting for 'SQL*Net message from client'
276:waiting for 'SQL*Net message from client'
287:waiting for 'SQL*Net message from client'
288:waiting for 'SQL*Net message from client'
290:waiting for 'SQL*Net message from client'
291:waiting for 'SQL*Net message from client'
292:waiting for 'SQL*Net message from client'
293:waiting for 'SQL*Net message from client'
294:waiting for 'SQL*Net message from client'
295:waiting for 'SQL*Net message from client'
296:waiting for 'SQL*Net message from client'
297:waiting for 'SQL*Net message from client'
307:waiting for 'SQL*Net message from client'
Blockers
~~~~~~~~
Above is a list of all the processes. If they are waiting for a resource
then it will be given in square brackets. Below is a summary of the
waited upon resources, together with the holder of that resource.
Notes:
~~~~~
o A process id of '???' implies that the holder was not found in the
systemstate.
Resource Holder State
Enqueue TX-00030017-0007166A 244: waiting for 'SQL*Net message from client'
Object Names
~~~~~~~~~~~~
Enqueue TX-00030017-0007166A
System State 2
~~~~~~~~~~~~~~~~
1:
2: waiting for 'pmon timer'
3: waiting for 'rdbms ipc message'
4: waiting for 'rdbms ipc message'
5: waiting for 'rdbms ipc message'
6: waiting for 'rdbms ipc message'
7: waiting for 'rdbms ipc message'
8: waiting for 'smon timer'
9: waiting for 'rdbms ipc message'
10: last wait for 'rdbms ipc message'
11: waiting for 'rdbms ipc message'
12: last wait for 'rdbms ipc message'
13:
14:
15: waiting for 'SQL*Net message from client'
16: waiting for 'rdbms ipc message'
17: waiting for 'rdbms ipc message'
18: waiting for 'rdbms ipc message'
19: waiting for 'Streams AQ: qmn coordinator idle wait'
20: waiting for 'SQL*Net message from client'
21: waiting for 'SQL*Net message from client'
22: waiting for 'SQL*Net message from client'
23: waiting for 'SQL*Net message from client'
24: waiting for 'SQL*Net message from client'
25: for 'Streams AQ: waiting for time management or cleanup tasks'
26: waiting for 'SQL*Net message from client'
27: waiting for 'SQL*Net message from client'
28: waiting for 'SQL*Net message from client'
29: waiting for 'SQL*Net message from client'
30: waiting for 'SQL*Net message from client'
31: waiting for 'Streams AQ: qmn slave idle wait'
32: waiting for 'SQL*Net message from client'
33: waiting for 'SQL*Net message from client'
34: waiting for 'SQL*Net message from client'
35: waiting for 'SQL*Net message from client'
36: waiting for 'SQL*Net message from client'
37: waiting for 'SQL*Net message from client'
38: waiting for 'SQL*Net message from client'
39: waiting for 'SQL*Net message from client'
40: waiting for 'SQL*Net message from client'
41: waiting for 'SQL*Net message from client'
42: waiting for 'SQL*Net message from client'
43: waiting for 'SQL*Net message from client'
44: waiting for 'SQL*Net message from client'
45: waiting for 'SQL*Net message from client'
46: waiting for 'SQL*Net message from client'
47: waiting for 'SQL*Net message from client'
48: waiting for 'SQL*Net message from client'
49: waiting for 'SQL*Net message from client'
50: waiting for 'SQL*Net message from client'
51: waiting for 'SQL*Net message from client'
52: waiting for 'SQL*Net message from client'
53: waiting for 'SQL*Net message from client'
54: waiting for 'SQL*Net message from client'
55: waiting for 'SQL*Net message from client'
56: waiting for 'SQL*Net message from client'
57: waiting for 'SQL*Net message from client'
58: waiting for 'SQL*Net message from client'
59: waiting for 'SQL*Net message from client'
60: waiting for 'SQL*Net message from client'
61: waiting for 'SQL*Net message from client'
62: waiting for 'SQL*Net message from client'
63: waiting for 'SQL*Net message from client'
64: waiting for 'SQL*Net message from client'
65: waiting for 'SQL*Net message from client'
66: waiting for 'SQL*Net message from client'
67: waiting for 'SQL*Net message from client'
68: waiting for 'SQL*Net message from client'
69: waiting for 'SQL*Net message from client'
70: waiting for 'SQL*Net message from client'
71: waiting for 'SQL*Net message from client'
72: waiting for 'SQL*Net message from client'
73: waiting for 'SQL*Net message from client'
74: waiting for 'SQL*Net message from client'
75: waiting for 'SQL*Net message from client'
76: waiting for 'SQL*Net message from client'
77: waiting for 'SQL*Net message from client'
78: waiting for 'SQL*Net message from client'
79: waiting for 'SQL*Net message from client'
80: waiting for 'SQL*Net message from client'
81: waiting for 'SQL*Net message from client'
82: waiting for 'SQL*Net message from client'
83: waiting for 'SQL*Net message from client'
84: waiting for 'SQL*Net message from client'
85: waiting for 'SQL*Net message from client'
86: waiting for 'SQL*Net message from client'
87: waiting for 'SQL*Net message from client'
88: waiting for 'SQL*Net message from client'
89: waiting for 'SQL*Net message from client'
90: waiting for 'SQL*Net message from client'
91: waiting for 'SQL*Net message from client'
92: waiting for 'SQL*Net message from client'
93: waiting for 'SQL*Net message from client'
94: waiting for 'SQL*Net message from client'
95: waiting for 'SQL*Net message from client'
96: waiting for 'SQL*Net message from client'
97: waiting for 'SQL*Net message from client'
98: waiting for 'SQL*Net message from client'
99: waiting for 'SQL*Net message from client'
100:waiting for 'SQL*Net message from client'
101:waiting for 'SQL*Net message from client'
102:waiting for 'SQL*Net message from client'
103:waiting for 'SQL*Net message from client'
104:waiting for 'SQL*Net message from client'
105:waiting for 'SQL*Net message from client'
106:waiting for 'SQL*Net message from client'
107:waiting for 'SQL*Net message from client'
108:waiting for 'SQL*Net message from client'
109:waiting for 'SQL*Net message from client'
110:waiting for 'SQL*Net message from client'
111:waiting for 'SQL*Net message from client'
112:waiting for 'SQL*Net message from client'
113:waiting for 'SQL*Net message from client'
114:waiting for 'SQL*Net message from client'
115:waiting for 'SQL*Net message from client'
116:waiting for 'SQL*Net message from client'
117:waiting for 'SQL*Net message from client'
118:waiting for 'SQL*Net message from client'
119:waiting for 'SQL*Net message from client'
120:waiting for 'SQL*Net message from client'
121:waiting for 'SQL*Net message from client'
122:waiting for 'SQL*Net message from client'
123:waiting for 'SQL*Net message from client'
124:waiting for 'SQL*Net message from client'
125:waiting for 'SQL*Net message from client'
126:waiting for 'SQL*Net message from client'
127:waiting for 'SQL*Net message from client'
128:waiting for 'SQL*Net message from client'
129:waiting for 'SQL*Net message from client'
130:waiting for 'SQL*Net message from client'
131:waiting for 'SQL*Net message from client'
132:waiting for 'SQL*Net message from client'
133:waiting for 'SQL*Net message from client'
134:waiting for 'SQL*Net message from client'
135:waiting for 'SQL*Net message from client'
136:waiting for 'SQL*Net message from client'
137:waiting for 'SQL*Net message from client'
138:waiting for 'SQL*Net message from client'
139:waiting for 'SQL*Net message from client'
140:waiting for 'SQL*Net message from client'
141:waiting for 'SQL*Net message from client'
142:waiting for 'SQL*Net message from client'
143:waiting for 'SQL*Net message from client'
144:waiting for 'SQL*Net message from client'
145:waiting for 'SQL*Net message from client'
146:waiting for 'SQL*Net message from client'
147:waiting for 'SQL*Net message from client'
148:waiting for 'SQL*Net message from client'
149:waiting for 'SQL*Net message from client'
150:waiting for 'SQL*Net message from client'
151:waiting for 'SQL*Net message from client'
152:waiting for 'SQL*Net message from client'
153:waiting for 'SQL*Net message from client'
154:waiting for 'SQL*Net message from client'
155:waiting for 'SQL*Net message from client'
156:waiting for 'SQL*Net message from client'
157:waiting for 'SQL*Net message from client'
158:waiting for 'SQL*Net message from client'
159:waiting for 'SQL*Net message from client'
160:waiting for 'SQL*Net message from client'
161:waiting for 'SQL*Net message from client'
162:waiting for 'SQL*Net message from client'
163:waiting for 'SQL*Net message from client'
164:waiting for 'SQL*Net message from client'
165:waiting for 'SQL*Net message from client'
166:waiting for 'SQL*Net message from client'
167:waiting for 'SQL*Net message from client'
168:waiting for 'SQL*Net message from client'
169:waiting for 'SQL*Net message from client'
170:waiting for 'SQL*Net message from client'
171:waiting for 'SQL*Net message from client'
172:waiting for 'SQL*Net message from client'
173:waiting for 'SQL*Net message from client'
174:waiting for 'SQL*Net message from client'
175:waiting for 'SQL*Net message from client'
176:waiting for 'SQL*Net message from client'
177:waiting for 'SQL*Net message from client'
178:waiting for 'SQL*Net message from client'
179:waiting for 'SQL*Net message from client'
180:waiting for 'SQL*Net message from client'
181:waiting for 'SQL*Net message from client'
182:waiting for 'SQL*Net message from client'
183:waiting for 'SQL*Net message from client'
184:waiting for 'SQL*Net message from client'
185:waiting for 'SQL*Net message from client'
186:waiting for 'SQL*Net message from client'
187:waiting for 'SQL*Net message from client'
188:waiting for 'SQL*Net message from client'
189:waiting for 'SQL*Net message from client'
190:waiting for 'SQL*Net message from client'
191:waiting for 'SQL*Net message from client'
192:waiting for 'SQL*Net message from client'
193:waiting for 'SQL*Net message from client'
194:waiting for 'SQL*Net message from client'
195:waiting for 'SQL*Net message from client'
196:waiting for 'SQL*Net message from client'
197:waiting for 'SQL*Net message from client'
198:waiting for 'SQL*Net message from client'
199:waiting for 'SQL*Net message from client'
200:waiting for 'SQL*Net message from client'
201:waiting for 'SQL*Net message from client'
202:waiting for 'SQL*Net message from client'
203:waiting for 'SQL*Net message from client'
204:waiting for 'SQL*Net message from client'
205:waiting for 'SQL*Net message from client'
206:waiting for 'SQL*Net message from client'
207:waiting for 'SQL*Net message from client'
208:waiting for 'SQL*Net message from client'
209:waiting for 'SQL*Net message from client'
210:waiting for 'SQL*Net message from client'
211:waiting for 'SQL*Net message from client'
212:waiting for 'SQL*Net message from client'
213:waiting for 'SQL*Net message from client'
214:waiting for 'SQL*Net message from client'
215:waiting for 'SQL*Net message from client'
216:waiting for 'SQL*Net message from client'
217:waiting for 'SQL*Net message from client'
218:waiting for 'SQL*Net message from client'
219:waiting for 'SQL*Net message from client'
220:waiting for 'SQL*Net message from client'
221:waiting for 'SQL*Net message from client'
222:waiting for 'SQL*Net message from client'
223:waiting for 'SQL*Net message from client'
224:waiting for 'SQL*Net message from client'
225:waiting for 'enq: TX - row lock contention'[Enqueue TX-00030017-0007166A]
Cmd: Update
226:waiting for 'SQL*Net message from client'
227:waiting for 'SQL*Net message from client'
228:waiting for 'SQL*Net message from client'
229:waiting for 'SQL*Net message from client'
230:waiting for 'SQL*Net message from client'
231:waiting for 'SQL*Net message from client'
232:waiting for 'SQL*Net message from client'
233:waiting for 'SQL*Net message from client'
234:waiting for 'SQL*Net message from client'
235:waiting for 'SQL*Net message from client'
236:waiting for 'SQL*Net message from client'
237:waiting for 'SQL*Net message from client'
238:waiting for 'SQL*Net message from client'
239:waiting for 'SQL*Net message from client'
240:waiting for 'SQL*Net message from client'
241:waiting for 'SQL*Net message from client'
242:waiting for 'SQL*Net message from client'
243:waiting for 'SQL*Net message from client'
244:waiting for 'SQL*Net message from client'
245:waiting for 'SQL*Net message from client'
246:waiting for 'SQL*Net message from client'
247:waiting for 'SQL*Net message from client'
248:waiting for 'enq: TX - row lock contention'[Enqueue TX-00030017-0007166A]
Cmd: Update
249:waiting for 'SQL*Net message from client'
250:waiting for 'SQL*Net message from client'
251:last wait for 'ksdxexeotherwait'
252:waiting for 'SQL*Net message from client'
253:waiting for 'SQL*Net message from client'
254:waiting for 'SQL*Net message from client'
255:waiting for 'SQL*Net message from client'
256:waiting for 'SQL*Net message from client'
257:waiting for 'SQL*Net message from client'
258:waiting for 'SQL*Net message from client'
259:waiting for 'SQL*Net message from client'
260:waiting for 'SQL*Net message from client'
261:waiting for 'SQL*Net message from client'
262:waiting for 'SQL*Net message from client'
263:waiting for 'SQL*Net message from client'
264:waiting for 'SQL*Net message from client'
265:waiting for 'jobq slave wait'
266:waiting for 'jobq slave wait'
267:last wait for 'jobq slave wait'
268:waiting for 'SQL*Net message from client'
272:waiting for 'SQL*Net message from client'
274:waiting for 'SQL*Net message from client'
276:waiting for 'SQL*Net message from client'
287:waiting for 'SQL*Net message from client'
288:waiting for 'SQL*Net message from client'
290:waiting for 'SQL*Net message from client'
291:waiting for 'SQL*Net message from client'
292:waiting for 'SQL*Net message from client'
293:waiting for 'SQL*Net message from client'
294:waiting for 'SQL*Net message from client'
295:waiting for 'SQL*Net message from client'
296:waiting for 'SQL*Net message from client'
297:waiting for 'SQL*Net message from client'
307:waiting for 'SQL*Net message from client'
Blockers
~~~~~~~~
Above is a list of all the processes. If they are waiting for a resource
then it will be given in square brackets. Below is a summary of the
waited upon resources, together with the holder of that resource.
Notes:
~~~~~
o A process id of '???' implies that the holder was not found in the
systemstate.
Resource Holder State
Enqueue TX-00030017-0007166A 244: waiting for 'SQL*Net message from client'
Object Names
~~~~~~~~~~~~
Enqueue TX-00030017-0007166A
300193 Lines Processed.格式化trace文件后，可以看出oracle pid 244 是block session 。
到此，关于“Oracle systemstate使用方法有哪些”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！
亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
原文链接：http://blog.itpub.net/15412087/viewspace-2650752/
