oracle 解锁
摘要：
1.表级解锁：select 'alter system kill session ',''''||trim(t2.sid)||','||trim(t2.serial#)||''';'from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time执行查询的语句2.用户解锁ALTER USER username ACCOUNT UNLOCK; 阅读全文
posted @ 2013-02-27 12:44 代码苦行僧 阅读(170) 评论(0) 推荐(0) 编辑