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

This article mainly shows you "Oracle kill how to lock the table", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "Oracle kill how to lock the table" this article.

-- kill process script

-- check the process--

Find the current process (pay attention to the libraries running)

SELECT OWNER

OBJECT_NAME AS object name

S.SID

S.SERIAL#

P.SPID AS system process number

FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S, V$PROCESS P

WHERE L.OBJECT_ID = O.OBJECT_ID

AND L.SESSION_ID = S.SID

AND S.PADDR = P.ADDR

Execution

(1) kill-9 p.spid (system process number)-directly valid @ kills processes at the system level

(2) alter system kill session '1427pc60590'-sometimes get stuck, but in the case of execution pass, it is very efficient, and the session is released directly.

Note: I prefer the first method of the above two!

The above is all the contents of the article "how to lock the table in Oracle kill". 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!

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.