<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lin_10的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lin_10</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lin_10]]></copyright><item><title><![CDATA[【整合】ORACLE、MYSQL出现锁表，手动kill掉进程]]></title><link>https://blog.youkuaiyun.com/lin_10/article/details/103958138</link><guid>https://blog.youkuaiyun.com/lin_10/article/details/103958138</guid><author>lin_10</author><pubDate>Mon, 13 Jan 2020 15:21:24 +0800</pubDate><description><![CDATA[ORACLE、MYSQL出现锁表，手动kill掉
1、ORACLE查出哪些是锁表的sql
select t2.username,t2,sid,t2.serial#,t2.logon_time from vlockedobjectt1,vlocked_object t1,vlockedo​bjectt1,vsession t2 where t1.session_id=t2.sid order by ...]]></description><category></category></item></channel></rss>