12/29/2023 0 Comments Sql profiler deadlock![]() ![]() Tells us this is data object 5173 - its in HEX. There are various apis in the dbms_rowid pacakge to get all of the information you select to_number( '00001435', 'xxxxxxxxxxx' ) from dual Shows that given a rowid from dual, I can find the object number and hence the object name. You use the dbms_rowid package to extract this info, for select rowid from select dbms_rowid.rowid_object( 'AAAADCAABAAAAHQAAA' ) from select object_name from all_objects where data_object_id = 194 Session 125: obj - rowid = 00001435 - AAEUluACwAAAY83AAB Session 62: obj - rowid = 00001435 - AAEUluADmAAAswlAAA Resource Name process session holds waits process session holds waits Information may aid in determining the deadlock: It is aĭeadlock due to user error in the design of an application The following deadlock is not an ORACLE error. UPDATE RA_INTERFACE_LINES_ALL SET LINE_GDF_ATTRIBUTE1=:b1,LINE_GDF_ATTRIBUTE2=DECODE(:b2, NULL ,DECODE(:b3, NULL ,:b4,:b3),LINE_GDF_ATTRIBUTE2),LINE_GDF_ATTRIBUTE3=DECODE(:b6, NULL ,:b7,:b6),LINE_GDF_ATTRIBUTE4=DECODE(:b9, NULL ,DECODE(:b10, NULL ,:b11,:b10),LINE_GDF_ATTRIBUTE4),LINE_GDF_ATTRIBUTE5=DECODE(:b13, NULL ,DECODE(:b14, NULL ,:b15,:b14),LINE_GDF_ATTRIBUTE5),LINE_GDF_ATTRIBUTE6=DECODE(:b17, NULL ,DECODE(:b18, NULL ,:b19,:b18),LINE_GDF_ATTRIBUTE6),LINE_GDF_ATTRIBUTE7=DECODE(:b21, NULL ,:b22,LINE_GDF_ATTRIBUTE7),HEADER_GDF_ATTR_CATEGORY=DECODE(:b23, NULL ,'JL.BR.ARXTWMAI.Additional Info',HEADER_GDF_ATTR_CATEGORY),LINE_GDF_ATTR_CATEGORY=DECODE(:b24, NULL ,'JL.BR.ARXTWMAI.Additional Info',LINE_GDF_ATTR_CATEGORY) WHERE ROWID = :b25 Would please elaborate on the whole output if possible ?Īnd how can prevent or at least avoid this situation ? How can I understand which two rows where involved in the following deadlock, which appears in this excerpt of a tracefile ?Įspecially in the last two lines, Oracle seems to convey this information, but I was not able to locate the object or the rowids. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |