Locked Sessions and Locked Objects
来源:互联网 发布:php 设置session id 编辑:程序博客网 时间:2024/06/05 20:49
col blocker_sid format 99999999999
col blocked_sid format 99999999999
col min_blocked format 99999999999
col request format 9999999
select /*+ ORDERED */
blocker.sid blocker_sid
, blocked.sid blocked_sid
, TRUNC(blocked.ctime/60) min_blocked
, blocked.request
from (select *
from v$lock
where block != 0
and type = 'TX') blocker
, v$lock blocked
where
blocked.type='TX'
and blocked.block = 0
and blocked.id1 = blocker.id1;
prompt blocked objects from V$LOCK and SYS.OBJ$
set lines 132
col BLOCKED_OBJ format a35 trunc
select /*+ ORDERED */
l.sid
, l.lmode
, TRUNC(l.ctime/60) min_blocked
, u.name||'.'||o.NAME blocked_obj
from (select *
from v$lock
where type='TM'
and sid in (select sid
from v$lock
where block!=0)) l
, sys.obj$ o
, sys.user$ u
where o.obj# = l.ID1
and o.OWNER# = u.user#
/
prompt blocked sessions from V$LOCK
select /*+ ORDERED */
blocker.sid blocker_sid
, blocked.sid blocked_sid
, TRUNC(blocked.ctime/60) min_blocked
, blocked.request
from (select *
from v$lock
where block != 0
and type = 'TX') blocker
, v$lock blocked
where blocked.type='TX'
and blocked.block = 0
and blocked.id1 = blocker.id1
/
prompt blokers session details from V$SESSION
set lines 132
col username format a10 trunc
col osuser format a12 trunc
col machine format a15 trunc
col process format a15 trunc
col action format a50 trunc
SELECT sid
, serial#
, username
, osuser
, machine
FROM v$session
WHERE sid IN (select sid
from v$lock
where block != 0
and type = 'TX')
/
- Locked Sessions and Locked Objects
- Mailbox locked and ready
- Display locked objects in a 10g database
- how many objects can be locked per transaction
- skip locked
- Skip Locked
- svn locked
- Locked锁
- svn locked
- Cannot log back into PC after being locked and idle...
- Working copy XXX locked and cleanup failed in SVN
- 并查集( Roads and Libraries locked)
- svn: E155004: *** locked 或 is already locked.
- Error:svn: locked svn: is already locked.
- the account is locked
- svn locked问题
- the account is locked
- the account is locked
- 【BFS】英雄(hero.cpp/pas)
- ASIFT
- 最好的HTML 5编码教程和参考手册分享
- 云计算时代:大数据泡沫正无限膨胀
- Web开发人员应当收藏的10个网站
- Locked Sessions and Locked Objects
- 使用office2003打开docx文件
- 最小生成树模版(Prime+邻接表)
- android游戏开发适应多屏幕的问题
- 博客的开始
- spring_01_核心技术
- spring_02_在中间层的使用
- spring_03_在Web层的应用.
- Sub-process /usr/bin/dpkg returned an error code (1) 的解决办法