How to check and kill the blocking of oracle

Editor to share with you how to check and kill oracle blocking, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Execute the following script to catch the current blockage:

Select

(select username | |':'| | sid | |':'| | serial# from v$session where sid=a.sid) | |

'locked' | |

(select username | |':'| | sid | |':'| | serial# from v$session where sid=b.sid)

From v$lock a, v$lock b

Where a.block = 1

And b.request > 0

And a.id1 = b.id1

And a.id2 = b.id2

Find the current blocking source:

Select b. SQL where a.SQL_HASH_VALUE b.HASH_VALUE. Sid. Seria # b.HASH_VALUE a, SQL b where a.SQL_HASH_VALUE = b.HASH_VALUE (+) and sid=&sid

Kill the current source of blockage:

Alter system kill session '5pr 35133.

The above is all the content of this article "how to check and kill oracle blockage". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!