oracle 查询数据库锁表
来源:互联网 发布:荆鹏软件 编辑:程序博客网 时间:2024/05/28 11:49
select LOCK_INFO.OWNER || '.' || LOCK_INFO.OBJ_NAME as "已鎖物件名稱", --物件名稱(已經被鎖住)
LOCK_INFO.SUBOBJ_NAME as "已鎖子物件名稱", -- 子物件名稱(已經被鎖住)
SESS_INFO.MACHINE as "機器名稱", -- 機器名稱
LOCK_INFO.SESSION_ID as "會話ID", -- 會話SESSION_ID
SESS_INFO.SERIAL# as "會話SERIAL#", -- 會話SERIAL#
SESS_INFO.SPID as "OS系統的SPID", -- OS系統的SPID
(SELECT INSTANCE_NAME FROM V$INSTANCE) "實例名SID", --實例名SID
LOCK_INFO.ORA_USERNAME as "ORACLE用戶", -- ORACLE系統用戶名稱
LOCK_INFO.OS_USERNAME as "OS用戶", -- 作業系統用戶名稱
LOCK_INFO.PROCESS as "進程編號", -- 進程編號
LOCK_INFO.OBJ_ID as "對象ID", -- 對象ID
LOCK_INFO.OBJ_TYPE as "對象類型", -- 對象類型
SESS_INFO.LOGON_TIME as "登錄時間", -- 登錄時間
SESS_INFO.PROGRAM as "程式名稱", -- 程式名稱
SESS_INFO.STATUS as "會話狀態", -- 會話狀態
SESS_INFO.LOCKWAIT as "等待鎖", -- 等待鎖
SESS_INFO.ACTION as "動作", -- 動作
SESS_INFO.CLIENT_INFO as "客戶資訊" -- 客戶資訊
from (select obj.OWNER as OWNER,
obj.OBJECT_NAME as OBJ_NAME,
obj.SUBOBJECT_NAME as SUBOBJ_NAME,
obj.OBJECT_ID as OBJ_ID,
obj.OBJECT_TYPE as OBJ_TYPE,
lock_obj.SESSION_ID as SESSION_ID,
lock_obj.ORACLE_USERNAME as ORA_USERNAME,
lock_obj.OS_USER_NAME as OS_USERNAME,
lock_obj.PROCESS as PROCESS
from (select *
from all_objects
where object_id in (select object_id from v$locked_object)) obj,
v$locked_object lock_obj
where obj.object_id = lock_obj.object_id) LOCK_INFO,
(select SID,
SERIAL#,
LOCKWAIT,
STATUS,
(select spid from v$process where addr = a.paddr) spid,
PROGRAM,
ACTION,
CLIENT_INFO,
LOGON_TIME,
MACHINE
from v$session a) SESS_INFO
where LOCK_INFO.SESSION_ID = SESS_INFO.SID
order by LOCK_INFO.SESSION_ID;
alter system kill session '2013, 11199';
alter system kill session '4020, 37381';
alter system kill session '5779, 42931';
- oracle 查询数据库锁表
- oracle数据库查询锁表和解锁
- Oracle数据库--表锁的情况查询
- oracle数据库查询锁表sql
- oracle 数据库表结构查询
- Oracle数据库表空间查询
- oracle数据库之多表查询
- oracle数据库员工表查询
- Oracle数据库之多表查询
- ORACLE数据库表空间查询
- oracle 数据库 多表查询
- oracle数据库表查询,空间查询
- Oracle查询数据库锁表和解除锁表
- oracle 数据库管理-查询锁表及解锁
- Oracle数据库管理--查询被锁的表
- Oracle数据库锁表查询以及解锁进程
- oracle数据库锁表查询及解锁sql
- 查询和删除 oracle 数据库中 锁死的表
- SQL Server表中自动复制数据
- JSP传递参数问题
- 将文件上传、下载(以二进制流保存到数据库)
- AndroidRuntime(21829): java.lang.NoClassDefFoundError
- 字符串专项:UVa 11475
- oracle 查询数据库锁表
- vmware虚拟机上ubuntu 10.04不能连上外网解决办法
- Qt基本常识(转载)
- GUI系统之SurfaceFlinger(3)Android中的本地窗口FramebufferNativewindow
- UCSC浏览器的安装
- 第10期中国智能家居主题沙龙将于5月25日在上海举办
- php最详细的配置文件(中文注释)
- 数据库设计规范化的五个要求
- 数学专项number_theory:UVa 10692