Home >Database >Mysql Tutorial >检索Oracle 锁住的表和解锁

检索Oracle 锁住的表和解锁

WBOY
WBOYOriginal
2016-06-07 16:59:17962browse

检索Oracle 锁住的表和解锁Sql代码:select object_name,machine,s.sid,s.serial#from v$locked_object l,dba_objects o ,v$sessi

检索Oracle 锁住的表和解锁

Sql代码:

select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session s
where l.object_id = o.object_id and l.session_id=s.sid;

用这条语句检索出被锁的信息。

再执行

Sql代码:

alter system kill session '[SID],[SERIAL]'; 

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn