Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do about ORACLE ORA-02049 errors. I hope you will get something after reading this article. Let's discuss it together.

1. Query which user caused the deadlock:

Select username,lockwait,status,machine,program from v$session where sid in

(select session_id from v$locked_object)

two。 Check the current system lock situation

SELECT / * + rule * /

Lpad ('', decode (l.xidusn, 0,3,0)) | | l.oracle_username User_name

O.owner

O.object_name

O.object_type

S.sid

S.serial#

FROM v$locked_object l, dba_objects o, v$session s

WHERE l.object_id = o.object_id

AND l.session_id = s.sid

ORDER BY o.object_id, xidusn DESC

View deadlocked statements

Select sql_text from v$sql where hash_value in

(select sql_hash_value from v$session where sid in (select session_id from v$locked_object))

3. Find deadlocked processes

SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#, l.ORACLE_USERNAME

L. OSEC USERNAME FROM V$LOCKED_OBJECT l.Process LMVOCESSION S

WHERE l.SESSION_ID=S.SID

4. Unlock and kill the deadlock process

Alter system kill session 'sid,serial#'

After reading this article, I believe you have a certain understanding of "how to report ORA-02049 errors in ORACLE". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.