oracle查询sys的表,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

原文：http://www.cnblogs.com/st-sun/p/3777579.html