oracle优化11

来源：互联网发布：影视剧知乎编辑：程序博客网时间：2024/05/16 12:14

SQL >SELECT SYS .V_$SESSION.OSUSER,
        SYS .V_$SESSION.MACHINE,
        V$LOCK.SID,
        SYS .V_$SESSION.SERIAL#,
        DECODE(V$LOCK.TYPE ,
               'MR' , 'MEDIA RECOVERY' ,
               'RT' , 'REDO THREAD' ,
               'UN' , 'USER NAME' ,
               'TX' , 'TRANSACTION' ,
               'TM' , 'DML' ,
               'UL' , 'PL/SQL USER LOCK' ,
               'DX' , 'DISTRIBUTED XACTION' ,
               'CF' , 'CONTROL FILE' ,
               'IS' , 'INSTANCE STATE' ,
               'FS' , 'FILE SET' ,
               'IR' , 'INSTANCE RECOVERY' ,
               'ST' , 'DISK SPACE TRANSACTION' ,
               'TS' , 'TEMP SEGMENT' ,
               'IV' , 'LIBRARY CACHE INVALIDA-TION' ,
               'LS' , 'LOG START OR SWITCH' ,
               'RW' , 'ROW WAIT' ,
               'SQ' , 'SEQUENCE NUMBER' ,
               'TE' , 'EXTEND TABLE' ,
               'TT' , 'TEMP TABLE' ,
               'UNKNOWN' ) LOCKTYPE,
        RTRIM(OBJECT_TYPE) || ' ' || RTRIM(OWNER) || '.' || OBJECT_NAME OBJECT_NAME,

0 0