oracle笔记

 

1、查看数据库中被锁的表记解锁

-- 查询被锁的表sql
select o.object_name, s.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;

-- 解锁sql
alter system kill session 'sid,serial#'

 

2、plsql执行sql脚本（@sql文件路径）

1、 @‪C:\Users\ASUS\Desktop\user.sql
2、 @‪"C:\Users\ASUS\Desktop\user.sql"