424   Oracle

1,锁表查询

SELECT object_name, machine, s.sid, s.serial# 
FROM gv$locked_object l, dba_objects o, gv$session s 
WHERE l.object_id = o.object_id 
AND l.session_id = s.sid;

2,释放表格


[oracle@v0A-123-177-205 ~]$  sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 30 18:06:04 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> ALTER system kill session '858, 55493';
SQL> 

‘858, 55493’对应’sid, serial#’;




Leave a Reply

Your email address will not be published. Required fields are marked *