正德厚生,臻于至善

DDL锁

V$ACCESS 显示数据库中当前被锁定的对象以及正在访问这些对象的会话。
V$ACCESS displays objects in the database that are currently locked and the sessions that are accessing them.
Column Datatype Description
SID NUMBER Session number that is accessing an object
OWNER VARCHAR2(64) Owner of the object
OBJECT VARCHAR2(1000) Name of the object
TYPE VARCHAR2(24) Type identifier for the object
--RAC
select 'alter system kill session ''' || s.sid || ',' || s.serial# || ',@' || s.inst_id || ''' immediate;'
from gv$session s,gv$access a
where s.inst_id=a.inst_id
and s.sid=a.sid
and a.object='CUX_5_FND_COMMON_PKG'
and a.owner='APPS';
--Single instance
select 'alter system kill session ''' || s.sid || ',' || s.serial# || ''' immediate;'
from v$session s,v$access a
where s.sid=a.sid
and a.object='CUX_5_FND_COMMON_PKG'
and a.owner='APPS';
--Single instance
SELECT SID,
         SERIAL#,
         PADDR,
         'alter system kill session ''' || sid || ',' || serial# || ''' immediate;'
    FROM V$SESSION
   WHERE SID in (select /*+ rule*/
      SID
       from V$ACCESS a
      WHERE a.object='CUX_5_FND_COMMON_PKG' and a.owner='APPS');
set lines 200 pages 50000
Select distinct 'ALTER SYSTEM DISCONNECT SESSION  ''' || b.sid ||','||b.SERIAL# || ',@' || b.INST_ID || ''' immediate;'
From dba_ddl_locks a, gv$session b
Where a.session_id=b.SID
And a.name =upper('CUX_5_FND_COMMON_PKG') and b.username=upper('APPS');
赞(0) 打赏
未经允许不得转载:徐万新之路 » DDL锁

支持快讯、专题、百度收录推送、人机验证、多级分类筛选器,适用于垂直站点、科技博客、个人站,扁平化设计、简洁白色、超多功能配置、会员中心、直达链接、文章图片弹窗、自动缩略图等...

联系我们

觉得文章有用就打赏一下文章作者

非常感谢你的打赏,我们将继续提供更多优质内容,让我们一起创建更加美好的网络世界!

支付宝扫一扫

微信扫一扫

登录

找回密码

注册