摘要: ----------查看被锁的对象select c.object_type AS 对象类型,c.object_name AS 对象名称,c.owner AS 所有者,b.username AS 用户,b.sid,b.serial#, b.STATUS,b.SCHEMANAME AS 所属架构,b.OSUSER 客户端用户,b.MACHINE 客户端名称 ,b.TERMINAL AS 终端,b.PROGRAM AS 程序 ,b.TYPE AS 会话类型,b.STATE AS 进程状态,b.SERVICE_NAME AS 服务器名,b.logon_time AS 登陆时间from v$locked 阅读全文
posted @ 2012-03-19 09:28 迷城探索 阅读(263) 评论(0) 推荐(0) 编辑