Oracle systemstate使用方法有哪些

这篇文章主要介绍"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).RACSQL>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 258

2.使用ass109.awk解析trace文件

$ awk -f /oracle/ORA10/10.2.0/ass109.awk ora10_ora_22855.trcStarting Systemstate 1........................................................................................................................................................................................................................................................................................Starting Systemstate 2..........................................................................................................................................................................................................................................................................................Ass.Awk Version 1.0.9 - Processing ora10_ora_22855.trcSystem 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: Update226: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: Update249: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 StateEnqueue 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: Update226: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: Update249: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 StateEnqueue 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使用方法有哪些"的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注网站，小编会继续努力为大家带来更多实用的文章！