这篇文章主要介绍“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 258
2.使用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使用方法有哪些”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注创新互联-成都网站建设公司网站,小编会继续努力为大家带来更多实用的文章!
当前名称:Oraclesystemstate使用方法有哪些-创新互联
分享地址:https://www.cdcxhl.com/article16/cspedg.html
成都网站建设公司_创新互联,为您提供网站改版、软件开发、ChatGPT、标签优化、全网营销推广、App设计
声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联