排查理由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
判断查询结果是否存在锁