查找并解决oracle表锁住的问题
1.查出哪些会话被锁住SELECT s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine,s.terminal, s.logon_time, l.typeFROM v$session s, v$lock lWHERE s.sid = l.sidAND s.username IS NOT NULLORDE...
原创
2018-04-18 16:22:11 ·
114 阅读 ·
0 评论