Oracle systemstate使用方法有哪些

2025-03-13 技术教程

这篇文章主要介绍“Oracle systemstate使用方法有哪些”，在日常操作中，相信很多人在Oracle systemstate使用方法有哪些问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Oracle systemstate使用方法有哪些”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

Oracle推荐的使用systemstate事件的几种情况是：

-数据库hang住了

-数据库很慢

-进程正在hang

-数据库出现某些错误

-资源争用

1.命令

sqlplus-prelim/assysdba(1).单实例SQL>oradebugsetmypidSQL>oradebugunlimitSQL>oradebugdumpsystemstate258等1~2分钟SQL>oradebugdumpsystemstate258等1~2分钟SQL>oradebugdumpsystemstate258(2).RACSQL>oradebugsetmypidSQL>oradebugunlimitSQL>oradebug-galldumpsystemstate258<==-gall表示针对所有实例生成dump等1~2分钟SQL>oradebug-galldumpsystemstate258等1~2分钟SQL>oradebug-galldumpsystemstate258

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

$awk-f/oracle/ORA10/10.2.0/ass109.awkora10_ora_22855.trcStartingSystemstate1........................................................................................................................................................................................................................................................................................StartingSystemstate2..........................................................................................................................................................................................................................................................................................Ass.AwkVersion1.0.9-Processingora10_ora_22855.trcSystemState1~~~~~~~~~~~~~~~~1:2:waitingfor'pmontimer'3:waitingfor'rdbmsipcmessage'4:waitingfor'rdbmsipcmessage'5:waitingfor'rdbmsipcmessage'6:waitingfor'rdbmsipcmessage'7:waitingfor'controlfileparallelwrite'8:waitingfor'smontimer'9:waitingfor'rdbmsipcmessage'10:waitingfor'rdbmsipcmessage'11:waitingfor'rdbmsipcmessage'12:waitingfor'rdbmsipcmessage'13:14:15:waitingfor'SQL*Netmessagefromclient'16:waitingfor'rdbmsipcmessage'17:waitingfor'rdbmsipcmessage'18:waitingfor'rdbmsipcmessage'19:waitingfor'StreamsAQ:qmncoordinatoridlewait'20:waitingfor'SQL*Netmessagefromclient'21:waitingfor'SQL*Netmessagefromclient'22:waitingfor'SQL*Netmessagefromclient'23:waitingfor'SQL*Netmessagefromclient'24:waitingfor'SQL*Netmessagefromclient'25:for'StreamsAQ:waitingfortimemanagementorcleanuptasks'26:waitingfor'SQL*Netmessagefromclient'27:waitingfor'SQL*Netmessagefromclient'28:waitingfor'SQL*Netmessagefromclient'29:waitingfor'SQL*Netmessagefromclient'30:waitingfor'SQL*Netmessagefromclient'31:waitingfor'StreamsAQ:qmnslaveidlewait'32:waitingfor'SQL*Netmessagefromclient'33:waitingfor'SQL*Netmessagefromclient'34:waitingfor'SQL*Netmessagefromclient'35:waitingfor'SQL*Netmessagefromclient'36:waitingfor'SQL*Netmessagefromclient'37:waitingfor'SQL*Netmessagefromclient'38:waitingfor'SQL*Netmessagefromclient'39:waitingfor'SQL*Netmessagefromclient'40:waitingfor'SQL*Netmessagefromclient'41:waitingfor'SQL*Netmessagefromclient'42:waitingfor'SQL*Netmessagefromclient'43:waitingfor'SQL*Netmessagefromclient'44:waitingfor'SQL*Netmessagefromclient'45:waitingfor'SQL*Netmessagefromclient'46:waitingfor'SQL*Netmessagefromclient'47:waitingfor'SQL*Netmessagefromclient'48:waitingfor'SQL*Netmessagefromclient'49:waitingfor'SQL*Netmessagefromclient'50:waitingfor'SQL*Netmessagefromclient'51:waitingfor'SQL*Netmessagefromclient'52:waitingfor'SQL*Netmessagefromclient'53:waitingfor'SQL*Netmessagefromclient'54:waitingfor'SQL*Netmessagefromclient'55:waitingfor'SQL*Netmessagefromclient'56:waitingfor'SQL*Netmessagefromclient'57:waitingfor'SQL*Netmessagefromclient'58:waitingfor'SQL*Netmessagefromclient'59:waitingfor'SQL*Netmessagefromclient'60:waitingfor'SQL*Netmessagefromclient'61:waitingfor'SQL*Netmessagefromclient'62:waitingfor'SQL*Netmessagefromclient'63:waitingfor'SQL*Netmessagefromclient'64:waitingfor'SQL*Netmessagefromclient'65:waitingfor'SQL*Netmessagefromclient'66:waitingfor'SQL*Netmessagefromclient'67:waitingfor'SQL*Netmessagefromclient'68:waitingfor'SQL*Netmessagefromclient'69:waitingfor'SQL*Netmessagefromclient'70:waitingfor'SQL*Netmessagefromclient'71:waitingfor'SQL*Netmessagefromclient'72:waitingfor'SQL*Netmessagefromclient'73:waitingfor'SQL*Netmessagefromclient'74:waitingfor'SQL*Netmessagefromclient'75:waitingfor'SQL*Netmessagefromclient'76:waitingfor'SQL*Netmessagefromclient'77:waitingfor'SQL*Netmessagefromclient'78:waitingfor'SQL*Netmessagefromclient'79:waitingfor'SQL*Netmessagefromclient'80:waitingfor'SQL*Netmessagefromclient'81:waitingfor'SQL*Netmessagefromclient'82:waitingfor'SQL*Netmessagefromclient'83:waitingfor'SQL*Netmessagefromclient'84:waitingfor'SQL*Netmessagefromclient'85:waitingfor'SQL*Netmessagefromclient'86:waitingfor'SQL*Netmessagefromclient'87:waitingfor'SQL*Netmessagefromclient'88:waitingfor'SQL*Netmessagefromclient'89:waitingfor'SQL*Netmessagefromclient'90:waitingfor'SQL*Netmessagefromclient'91:waitingfor'SQL*Netmessagefromclient'92:waitingfor'SQL*Netmessagefromclient'93:waitingfor'SQL*Netmessagefromclient'94:waitingfor'SQL*Netmessagefromclient'95:waitingfor'SQL*Netmessagefromclient'96:waitingfor'SQL*Netmessagefromclient'97:waitingfor'SQL*Netmessagefromclient'98:waitingfor'SQL*Netmessagefromclient'99:waitingfor'SQL*Netmessagefromclient'100:waitingfor'SQL*Netmessagefromclient'101:waitingfor'SQL*Netmessagefromclient'102:waitingfor'SQL*Netmessagefromclient'103:waitingfor'SQL*Netmessagefromclient'104:waitingfor'SQL*Netmessagefromclient'105:waitingfor'SQL*Netmessagefromclient'106:waitingfor'SQL*Netmessagefromclient'107:waitingfor'SQL*Netmessagefromclient'108:waitingfor'SQL*Netmessagefromclient'109:waitingfor'SQL*Netmessagefromclient'110:waitingfor'SQL*Netmessagefromclient'111:waitingfor'SQL*Netmessagefromclient'112:waitingfor'SQL*Netmessagefromclient'113:waitingfor'SQL*Netmessagefromclient'114:waitingfor'SQL*Netmessagefromclient'115:waitingfor'SQL*Netmessagefromclient'116:waitingfor'SQL*Netmessagefromclient'117:waitingfor'SQL*Netmessagefromclient'118:waitingfor'SQL*Netmessagefromclient'119:waitingfor'SQL*Netmessagefromclient'120:waitingfor'SQL*Netmessagefromclient'121:waitingfor'SQL*Netmessagefromclient'122:waitingfor'SQL*Netmessagefromclient'123:waitingfor'SQL*Netmessagefromclient'124:waitingfor'SQL*Netmessagefromclient'125:waitingfor'SQL*Netmessagefromclient'126:waitingfor'SQL*Netmessagefromclient'127:waitingfor'SQL*Netmessagefromclient'128:waitingfor'SQL*Netmessagefromclient'129:waitingfor'SQL*Netmessagefromclient'130:waitingfor'SQL*Netmessagefromclient'131:waitingfor'SQL*Netmessagefromclient'132:waitingfor'SQL*Netmessagefromclient'133:waitingfor'SQL*Netmessagefromclient'134:waitingfor'SQL*Netmessagefromclient'135:waitingfor'SQL*Netmessagefromclient'136:waitingfor'SQL*Netmessagefromclient'137:waitingfor'SQL*Netmessagefromclient'138:waitingfor'SQL*Netmessagefromclient'139:waitingfor'SQL*Netmessagefromclient'140:waitingfor'SQL*Netmessagefromclient'141:waitingfor'SQL*Netmessagefromclient'142:waitingfor'SQL*Netmessagefromclient'143:waitingfor'SQL*Netmessagefromclient'144:waitingfor'SQL*Netmessagefromclient'145:waitingfor'SQL*Netmessagefromclient'146:waitingfor'SQL*Netmessagefromclient'147:waitingfor'SQL*Netmessagefromclient'148:waitingfor'SQL*Netmessagefromclient'149:waitingfor'SQL*Netmessagefromclient'150:waitingfor'SQL*Netmessagefromclient'151:waitingfor'SQL*Netmessagefromclient'152:waitingfor'SQL*Netmessagefromclient'153:waitingfor'SQL*Netmessagefromclient'154:waitingfor'SQL*Netmessagefromclient'155:waitingfor'SQL*Netmessagefromclient'156:waitingfor'SQL*Netmessagefromclient'157:waitingfor'SQL*Netmessagefromclient'158:waitingfor'SQL*Netmessagefromclient'159:waitingfor'SQL*Netmessagefromclient'160:waitingfor'SQL*Netmessagefromclient'161:waitingfor'SQL*Netmessagefromclient'162:waitingfor'SQL*Netmessagefromclient'163:waitingfor'SQL*Netmessagefromclient'164:waitingfor'SQL*Netmessagefromclient'165:waitingfor'SQL*Netmessagefromclient'166:waitingfor'SQL*Netmessagefromclient'167:waitingfor'SQL*Netmessagefromclient'168:waitingfor'SQL*Netmessagefromclient'169:waitingfor'SQL*Netmessagefromclient'170:waitingfor'SQL*Netmessagefromclient'171:waitingfor'SQL*Netmessagefromclient'172:waitingfor'SQL*Netmessagefromclient'173:waitingfor'SQL*Netmessagefromclient'174:waitingfor'SQL*Netmessagefromclient'175:waitingfor'SQL*Netmessagefromclient'176:waitingfor'SQL*Netmessagefromclient'177:waitingfor'SQL*Netmessagefromclient'178:waitingfor'SQL*Netmessagefromclient'179:waitingfor'SQL*Netmessagefromclient'180:waitingfor'SQL*Netmessagefromclient'181:waitingfor'SQL*Netmessagefromclient'182:waitingfor'SQL*Netmessagefromclient'183:waitingfor'SQL*Netmessagefromclient'184:waitingfor'SQL*Netmessagefromclient'185:waitingfor'SQL*Netmessagefromclient'186:waitingfor'SQL*Netmessagefromclient'187:waitingfor'SQL*Netmessagefromclient'188:waitingfor'SQL*Netmessagefromclient'189:waitingfor'SQL*Netmessagefromclient'190:waitingfor'SQL*Netmessagefromclient'191:waitingfor'SQL*Netmessagefromclient'192:waitingfor'SQL*Netmessagefromclient'193:waitingfor'SQL*Netmessagefromclient'194:waitingfor'SQL*Netmessagefromclient'195:waitingfor'SQL*Netmessagefromclient'196:waitingfor'SQL*Netmessagefromclient'197:waitingfor'SQL*Netmessagefromclient'198:waitingfor'SQL*Netmessagefromclient'199:waitingfor'SQL*Netmessagefromclient'200:waitingfor'SQL*Netmessagefromclient'201:waitingfor'SQL*Netmessagefromclient'202:waitingfor'SQL*Netmessagefromclient'203:waitingfor'SQL*Netmessagefromclient'204:waitingfor'SQL*Netmessagefromclient'205:waitingfor'SQL*Netmessagefromclient'206:waitingfor'SQL*Netmessagefromclient'207:waitingfor'SQL*Netmessagefromclient'208:waitingfor'SQL*Netmessagefromclient'209:waitingfor'SQL*Netmessagefromclient'210:waitingfor'SQL*Netmessagefromclient'211:waitingfor'SQL*Netmessagefromclient'212:waitingfor'SQL*Netmessagefromclient'213:waitingfor'SQL*Netmessagefromclient'214:waitingfor'SQL*Netmessagefromclient'215:waitingfor'SQL*Netmessagefromclient'216:waitingfor'SQL*Netmessagefromclient'217:waitingfor'SQL*Netmessagefromclient'218:waitingfor'SQL*Netmessagefromclient'219:waitingfor'SQL*Netmessagefromclient'220:waitingfor'SQL*Netmessagefromclient'221:waitingfor'SQL*Netmessagefromclient'222:waitingfor'SQL*Netmessagefromclient'223:waitingfor'SQL*Netmessagefromclient'224:waitingfor'SQL*Netmessagefromclient'225:waitingfor'enq:TX-rowlockcontention'[EnqueueTX-00030017-0007166A]Cmd:Update226:waitingfor'SQL*Netmessagefromclient'227:waitingfor'SQL*Netmessagefromclient'228:waitingfor'SQL*Netmessagefromclient'229:waitingfor'SQL*Netmessagefromclient'230:waitingfor'SQL*Netmessagefromclient'231:waitingfor'SQL*Netmessagefromclient'232:waitingfor'SQL*Netmessagefromclient'233:waitingfor'SQL*Netmessagefromclient'234:waitingfor'SQL*Netmessagefromclient'235:waitingfor'SQL*Netmessagefromclient'236:waitingfor'SQL*Netmessagefromclient'237:waitingfor'SQL*Netmessagefromclient'238:waitingfor'SQL*Netmessagefromclient'239:waitingfor'SQL*Netmessagefromclient'240:waitingfor'SQL*Netmessagefromclient'241:waitingfor'SQL*Netmessagefromclient'242:waitingfor'SQL*Netmessagefromclient'243:waitingfor'SQL*Netmessagefromclient'244:waitingfor'SQL*Netmessagefromclient'245:waitingfor'SQL*Netmessagefromclient'246:waitingfor'SQL*Netmessagefromclient'247:waitingfor'SQL*Netmessagefromclient'248:waitingfor'enq:TX-rowlockcontention'[EnqueueTX-00030017-0007166A]Cmd:Update249:waitingfor'SQL*Netmessagefromclient'250:waitingfor'SQL*Netmessagefromclient'251:lastwaitfor'ksdxexeotherwait'252:waitingfor'SQL*Netmessagefromclient'253:waitingfor'SQL*Netmessagefromclient'254:waitingfor'SQL*Netmessagefromclient'255:waitingfor'SQL*Netmessagefromclient'256:waitingfor'SQL*Netmessagefromclient'257:waitingfor'SQL*Netmessagefromclient'258:waitingfor'SQL*Netmessagefromclient'259:waitingfor'SQL*Netmessagefromclient'260:waitingfor'SQL*Netmessagefromclient'261:waitingfor'SQL*Netmessagefromclient'262:waitingfor'SQL*Netmessagefromclient'263:waitingfor'SQL*Netmessagefromclient'264:waitingfor'SQL*Netmessagefromclient'265:waitingfor'jobqslavewait'266:waitingfor'jobqslavewait'272:waitingfor'SQL*Netmessagefromclient'274:waitingfor'SQL*Netmessagefromclient'276:waitingfor'SQL*Netmessagefromclient'287:waitingfor'SQL*Netmessagefromclient'288:waitingfor'SQL*Netmessagefromclient'290:waitingfor'SQL*Netmessagefromclient'291:waitingfor'SQL*Netmessagefromclient'292:waitingfor'SQL*Netmessagefromclient'293:waitingfor'SQL*Netmessagefromclient'294:waitingfor'SQL*Netmessagefromclient'295:waitingfor'SQL*Netmessagefromclient'296:waitingfor'SQL*Netmessagefromclient'297:waitingfor'SQL*Netmessagefromclient'307:waitingfor'SQL*Netmessagefromclient'Blockers~~~~~~~~Aboveisalistofalltheprocesses.Iftheyarewaitingforaresourcethenitwillbegiveninsquarebrackets.Belowisasummaryofthewaiteduponresources,togetherwiththeholderofthatresource.Notes:~~~~~oAprocessidof'???'impliesthattheholderwasnotfoundinthesystemstate.ResourceHolderStateEnqueueTX-00030017-0007166A244:waitingfor'SQL*Netmessagefromclient'ObjectNames~~~~~~~~~~~~EnqueueTX-00030017-0007166ASystemState2~~~~~~~~~~~~~~~~1:2:waitingfor'pmontimer'3:waitingfor'rdbmsipcmessage'4:waitingfor'rdbmsipcmessage'5:waitingfor'rdbmsipcmessage'6:waitingfor'rdbmsipcmessage'7:waitingfor'rdbmsipcmessage'8:waitingfor'smontimer'9:waitingfor'rdbmsipcmessage'10:lastwaitfor'rdbmsipcmessage'11:waitingfor'rdbmsipcmessage'12:lastwaitfor'rdbmsipcmessage'13:14:15:waitingfor'SQL*Netmessagefromclient'16:waitingfor'rdbmsipcmessage'17:waitingfor'rdbmsipcmessage'18:waitingfor'rdbmsipcmessage'19:waitingfor'StreamsAQ:qmncoordinatoridlewait'20:waitingfor'SQL*Netmessagefromclient'21:waitingfor'SQL*Netmessagefromclient'22:waitingfor'SQL*Netmessagefromclient'23:waitingfor'SQL*Netmessagefromclient'24:waitingfor'SQL*Netmessagefromclient'25:for'StreamsAQ:waitingfortimemanagementorcleanuptasks'26:waitingfor'SQL*Netmessagefromclient'27:waitingfor'SQL*Netmessagefromclient'28:waitingfor'SQL*Netmessagefromclient'29:waitingfor'SQL*Netmessagefromclient'30:waitingfor'SQL*Netmessagefromclient'31:waitingfor'StreamsAQ:qmnslaveidlewait'32:waitingfor'SQL*Netmessagefromclient'33:waitingfor'SQL*Netmessagefromclient'34:waitingfor'SQL*Netmessagefromclient'35:waitingfor'SQL*Netmessagefromclient'36:waitingfor'SQL*Netmessagefromclient'37:waitingfor'SQL*Netmessagefromclient'38:waitingfor'SQL*Netmessagefromclient'39:waitingfor'SQL*Netmessagefromclient'40:waitingfor'SQL*Netmessagefromclient'41:waitingfor'SQL*Netmessagefromclient'42:waitingfor'SQL*Netmessagefromclient'43:waitingfor'SQL*Netmessagefromclient'44:waitingfor'SQL*Netmessagefromclient'45:waitingfor'SQL*Netmessagefromclient'46:waitingfor'SQL*Netmessagefromclient'47:waitingfor'SQL*Netmessagefromclient'48:waitingfor'SQL*Netmessagefromclient'49:waitingfor'SQL*Netmessagefromclient'50:waitingfor'SQL*Netmessagefromclient'51:waitingfor'SQL*Netmessagefromclient'52:waitingfor'SQL*Netmessagefromclient'53:waitingfor'SQL*Netmessagefromclient'54:waitingfor'SQL*Netmessagefromclient'55:waitingfor'SQL*Netmessagefromclient'56:waitingfor'SQL*Netmessagefromclient'57:waitingfor'SQL*Netmessagefromclient'58:waitingfor'SQL*Netmessagefromclient'59:waitingfor'SQL*Netmessagefromclient'60:waitingfor'SQL*Netmessagefromclient'61:waitingfor'SQL*Netmessagefromclient'62:waitingfor'SQL*Netmessagefromclient'63:waitingfor'SQL*Netmessagefromclient'64:waitingfor'SQL*Netmessagefromclient'65:waitingfor'SQL*Netmessagefromclient'66:waitingfor'SQL*Netmessagefromclient'67:waitingfor'SQL*Netmessagefromclient'68:waitingfor'SQL*Netmessagefromclient'69:waitingfor'SQL*Netmessagefromclient'70:waitingfor'SQL*Netmessagefromclient'71:waitingfor'SQL*Netmessagefromclient'72:waitingfor'SQL*Netmessagefromclient'73:waitingfor'SQL*Netmessagefromclient'74:waitingfor'SQL*Netmessagefromclient'75:waitingfor'SQL*Netmessagefromclient'76:waitingfor'SQL*Netmessagefromclient'77:waitingfor'SQL*Netmessagefromclient'78:waitingfor'SQL*Netmessagefromclient'79:waitingfor'SQL*Netmessagefromclient'80:waitingfor'SQL*Netmessagefromclient'81:waitingfor'SQL*Netmessagefromclient'82:waitingfor'SQL*Netmessagefromclient'83:waitingfor'SQL*Netmessagefromclient'84:waitingfor'SQL*Netmessagefromclient'85:waitingfor'SQL*Netmessagefromclient'86:waitingfor'SQL*Netmessagefromclient'87:waitingfor'SQL*Netmessagefromclient'88:waitingfor'SQL*Netmessagefromclient'89:waitingfor'SQL*Netmessagefromclient'90:waitingfor'SQL*Netmessagefromclient'91:waitingfor'SQL*Netmessagefromclient'92:waitingfor'SQL*Netmessagefromclient'93:waitingfor'SQL*Netmessagefromclient'94:waitingfor'SQL*Netmessagefromclient'95:waitingfor'SQL*Netmessagefromclient'96:waitingfor'SQL*Netmessagefromclient'97:waitingfor'SQL*Netmessagefromclient'98:waitingfor'SQL*Netmessagefromclient'99:waitingfor'SQL*Netmessagefromclient'100:waitingfor'SQL*Netmessagefromclient'101:waitingfor'SQL*Netmessagefromclient'102:waitingfor'SQL*Netmessagefromclient'103:waitingfor'SQL*Netmessagefromclient'104:waitingfor'SQL*Netmessagefromclient'105:waitingfor'SQL*Netmessagefromclient'106:waitingfor'SQL*Netmessagefromclient'107:waitingfor'SQL*Netmessagefromclient'108:waitingfor'SQL*Netmessagefromclient'109:waitingfor'SQL*Netmessagefromclient'110:waitingfor'SQL*Netmessagefromclient'111:waitingfor'SQL*Netmessagefromclient'112:waitingfor'SQL*Netmessagefromclient'113:waitingfor'SQL*Netmessagefromclient'114:waitingfor'SQL*Netmessagefromclient'115:waitingfor'SQL*Netmessagefromclient'116:waitingfor'SQL*Netmessagefromclient'117:waitingfor'SQL*Netmessagefromclient'118:waitingfor'SQL*Netmessagefromclient'119:waitingfor'SQL*Netmessagefromclient'120:waitingfor'SQL*Netmessagefromclient'121:waitingfor'SQL*Netmessagefromclient'122:waitingfor'SQL*Netmessagefromclient'123:waitingfor'SQL*Netmessagefromclient'124:waitingfor'SQL*Netmessagefromclient'125:waitingfor'SQL*Netmessagefromclient'126:waitingfor'SQL*Netmessagefromclient'127:waitingfor'SQL*Netmessagefromclient'128:waitingfor'SQL*Netmessagefromclient'129:waitingfor'SQL*Netmessagefromclient'130:waitingfor'SQL*Netmessagefromclient'131:waitingfor'SQL*Netmessagefromclient'132:waitingfor'SQL*Netmessagefromclient'133:waitingfor'SQL*Netmessagefromclient'134:waitingfor'SQL*Netmessagefromclient'135:waitingfor'SQL*Netmessagefromclient'136:waitingfor'SQL*Netmessagefromclient'137:waitingfor'SQL*Netmessagefromclient'138:waitingfor'SQL*Netmessagefromclient'139:waitingfor'SQL*Netmessagefromclient'140:waitingfor'SQL*Netmessagefromclient'141:waitingfor'SQL*Netmessagefromclient'142:waitingfor'SQL*Netmessagefromclient'143:waitingfor'SQL*Netmessagefromclient'144:waitingfor'SQL*Netmessagefromclient'145:waitingfor'SQL*Netmessagefromclient'146:waitingfor'SQL*Netmessagefromclient'147:waitingfor'SQL*Netmessagefromclient'148:waitingfor'SQL*Netmessagefromclient'149:waitingfor'SQL*Netmessagefromclient'150:waitingfor'SQL*Netmessagefromclient'151:waitingfor'SQL*Netmessagefromclient'152:waitingfor'SQL*Netmessagefromclient'153:waitingfor'SQL*Netmessagefromclient'154:waitingfor'SQL*Netmessagefromclient'155:waitingfor'SQL*Netmessagefromclient'156:waitingfor'SQL*Netmessagefromclient'157:waitingfor'SQL*Netmessagefromclient'158:waitingfor'SQL*Netmessagefromclient'159:waitingfor'SQL*Netmessagefromclient'160:waitingfor'SQL*Netmessagefromclient'161:waitingfor'SQL*Netmessagefromclient'162:waitingfor'SQL*Netmessagefromclient'163:waitingfor'SQL*Netmessagefromclient'164:waitingfor'SQL*Netmessagefromclient'165:waitingfor'SQL*Netmessagefromclient'166:waitingfor'SQL*Netmessagefromclient'167:waitingfor'SQL*Netmessagefromclient'168:waitingfor'SQL*Netmessagefromclient'169:waitingfor'SQL*Netmessagefromclient'170:waitingfor'SQL*Netmessagefromclient'171:waitingfor'SQL*Netmessagefromclient'172:waitingfor'SQL*Netmessagefromclient'173:waitingfor'SQL*Netmessagefromclient'174:waitingfor'SQL*Netmessagefromclient'175:waitingfor'SQL*Netmessagefromclient'176:waitingfor'SQL*Netmessagefromclient'177:waitingfor'SQL*Netmessagefromclient'178:waitingfor'SQL*Netmessagefromclient'179:waitingfor'SQL*Netmessagefromclient'180:waitingfor'SQL*Netmessagefromclient'181:waitingfor'SQL*Netmessagefromclient'182:waitingfor'SQL*Netmessagefromclient'183:waitingfor'SQL*Netmessagefromclient'184:waitingfor'SQL*Netmessagefromclient'185:waitingfor'SQL*Netmessagefromclient'186:waitingfor'SQL*Netmessagefromclient'187:waitingfor'SQL*Netmessagefromclient'188:waitingfor'SQL*Netmessagefromclient'189:waitingfor'SQL*Netmessagefromclient'190:waitingfor'SQL*Netmessagefromclient'191:waitingfor'SQL*Netmessagefromclient'192:waitingfor'SQL*Netmessagefromclient'193:waitingfor'SQL*Netmessagefromclient'194:waitingfor'SQL*Netmessagefromclient'195:waitingfor'SQL*Netmessagefromclient'196:waitingfor'SQL*Netmessagefromclient'197:waitingfor'SQL*Netmessagefromclient'198:waitingfor'SQL*Netmessagefromclient'199:waitingfor'SQL*Netmessagefromclient'200:waitingfor'SQL*Netmessagefromclient'201:waitingfor'SQL*Netmessagefromclient'202:waitingfor'SQL*Netmessagefromclient'203:waitingfor'SQL*Netmessagefromclient'204:waitingfor'SQL*Netmessagefromclient'205:waitingfor'SQL*Netmessagefromclient'206:waitingfor'SQL*Netmessagefromclient'207:waitingfor'SQL*Netmessagefromclient'208:waitingfor'SQL*Netmessagefromclient'209:waitingfor'SQL*Netmessagefromclient'210:waitingfor'SQL*Netmessagefromclient'211:waitingfor'SQL*Netmessagefromclient'212:waitingfor'SQL*Netmessagefromclient'213:waitingfor'SQL*Netmessagefromclient'214:waitingfor'SQL*Netmessagefromclient'215:waitingfor'SQL*Netmessagefromclient'216:waitingfor'SQL*Netmessagefromclient'217:waitingfor'SQL*Netmessagefromclient'218:waitingfor'SQL*Netmessagefromclient'219:waitingfor'SQL*Netmessagefromclient'220:waitingfor'SQL*Netmessagefromclient'221:waitingfor'SQL*Netmessagefromclient'222:waitingfor'SQL*Netmessagefromclient'223:waitingfor'SQL*Netmessagefromclient'224:waitingfor'SQL*Netmessagefromclient'225:waitingfor'enq:TX-rowlockcontention'[EnqueueTX-00030017-0007166A]Cmd:Update226:waitingfor'SQL*Netmessagefromclient'227:waitingfor'SQL*Netmessagefromclient'228:waitingfor'SQL*Netmessagefromclient'229:waitingfor'SQL*Netmessagefromclient'230:waitingfor'SQL*Netmessagefromclient'231:waitingfor'SQL*Netmessagefromclient'232:waitingfor'SQL*Netmessagefromclient'233:waitingfor'SQL*Netmessagefromclient'234:waitingfor'SQL*Netmessagefromclient'235:waitingfor'SQL*Netmessagefromclient'236:waitingfor'SQL*Netmessagefromclient'237:waitingfor'SQL*Netmessagefromclient'238:waitingfor'SQL*Netmessagefromclient'239:waitingfor'SQL*Netmessagefromclient'240:waitingfor'SQL*Netmessagefromclient'241:waitingfor'SQL*Netmessagefromclient'242:waitingfor'SQL*Netmessagefromclient'243:waitingfor'SQL*Netmessagefromclient'244:waitingfor'SQL*Netmessagefromclient'245:waitingfor'SQL*Netmessagefromclient'246:waitingfor'SQL*Netmessagefromclient'247:waitingfor'SQL*Netmessagefromclient'248:waitingfor'enq:TX-rowlockcontention'[EnqueueTX-00030017-0007166A]Cmd:Update249:waitingfor'SQL*Netmessagefromclient'250:waitingfor'SQL*Netmessagefromclient'251:lastwaitfor'ksdxexeotherwait'252:waitingfor'SQL*Netmessagefromclient'253:waitingfor'SQL*Netmessagefromclient'254:waitingfor'SQL*Netmessagefromclient'255:waitingfor'SQL*Netmessagefromclient'256:waitingfor'SQL*Netmessagefromclient'257:waitingfor'SQL*Netmessagefromclient'258:waitingfor'SQL*Netmessagefromclient'259:waitingfor'SQL*Netmessagefromclient'260:waitingfor'SQL*Netmessagefromclient'261:waitingfor'SQL*Netmessagefromclient'262:waitingfor'SQL*Netmessagefromclient'263:waitingfor'SQL*Netmessagefromclient'264:waitingfor'SQL*Netmessagefromclient'265:waitingfor'jobqslavewait'266:waitingfor'jobqslavewait'267:lastwaitfor'jobqslavewait'268:waitingfor'SQL*Netmessagefromclient'272:waitingfor'SQL*Netmessagefromclient'274:waitingfor'SQL*Netmessagefromclient'276:waitingfor'SQL*Netmessagefromclient'287:waitingfor'SQL*Netmessagefromclient'288:waitingfor'SQL*Netmessagefromclient'290:waitingfor'SQL*Netmessagefromclient'291:waitingfor'SQL*Netmessagefromclient'292:waitingfor'SQL*Netmessagefromclient'293:waitingfor'SQL*Netmessagefromclient'294:waitingfor'SQL*Netmessagefromclient'295:waitingfor'SQL*Netmessagefromclient'296:waitingfor'SQL*Netmessagefromclient'297:waitingfor'SQL*Netmessagefromclient'307:waitingfor'SQL*Netmessagefromclient'Blockers~~~~~~~~Aboveisalistofalltheprocesses.Iftheyarewaitingforaresourcethenitwillbegiveninsquarebrackets.Belowisasummaryofthewaiteduponresources,togetherwiththeholderofthatresource.Notes:~~~~~oAprocessidof'???'impliesthattheholderwasnotfoundinthesystemstate.ResourceHolderStateEnqueueTX-00030017-0007166A244:waitingfor'SQL*Netmessagefromclient'ObjectNames~~~~~~~~~~~~EnqueueTX-00030017-0007166A300193LinesProcessed.

格式化trace文件后，可以看出oracle pid 244 是block session 。

到此，关于“Oracle systemstate使用方法有哪些”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！