Shulou(Shulou.com)06/01 Report--

SELECT b.session_id AS sid, NVL (b.oracle_username,'(oracle)') AS username, a.owner AS object_owner, a.object_name, Decode (b.locked_mode, 0, 'None', 1,' Null (NULL), 2, 'Row-S (SS)' 3, 'Row-X (SX)', 4, 'Share (S)', 5, 'S/Row-X (SSX)', 6, 'Exclusive (X)', b.locked_mode) locked_mode B.os_user_name FROM dba_objects a, v$locked_object b WHERE a.object_id = b.object_id ORDER BY 1,2,3,4

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.