oracle 死锁及锁的导致cpu高、内存高的排查详细过程

排查理由CPU高内存高

通过查询视图，找到被锁住的对象v$locked_object，根据其locked_mode，判断其锁类型

select l.xidusn, l.object_id, o.owner, o.object_name, l.session_id, l.oracle_username, l.os_user_name, l.process, decode(l.locked_mode, 0, '',        1, 'NULL',        2, '(SS)',        3, '(SX)',        4, '(S)',        5, '(SSX)',        6, '(X)',        '???') locked_mode from v$locked_object l, dba_objects o where l.object_id = o.object_id

判断查询结果是否存在锁