<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wangxiao236的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/wangxiao236</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wangxiao236]]></copyright><item><title><![CDATA[orcale查看被锁定的表]]></title><link>https://blog.youkuaiyun.com/wangxiao236/article/details/76602636</link><guid>https://blog.youkuaiyun.com/wangxiao236/article/details/76602636</guid><author>wangxiao236</author><pubDate>Thu, 03 Aug 2017 09:13:39 +0800</pubDate><description><![CDATA[1.查看被锁的表
   select p.spid,a.serial#,a.sid,a.username,c.object_name,b.session_id,
   b.oracle_username,b.os_user_name
   from v$process p,v$session a,v$locked_object b,all_objects c 
   where p.add]]></description><category></category></item></channel></rss>