Oracle EBS-SQL (SYS-10):锁定表查询.sql
/*死锁查询-1*/SELECT o.object_name,
l.session_id,l.process,
l.locked_mode FROM v$locked_object l ,
dba_objects o WHERE
o.object_id=l.object_id
------------------------------------------------
/*死锁查询-2*/
select GL.SESSION_ID,
do.object_name,
GL.PROCESS,
GL.LOCKED_MODE,
GL.ORACLE_USERNAME,
GL.PROCESS
from gv$locked_object GL,
DBA_OBJECTS DO
WHERE GL.OBJECT_ID = DO.object_id
order by
do.object_name
页:
[1]