Can anyone help on this?

16         gv$locked_object b

17  WHERE  a.object_id = b.object_id

18  ORDER BY 1, 2, 3, 4;

   INST_ID        SID USERNAME             OBJECT_OWNER         OBJECT_NAME                    LOCKED_MODE     OS_USER_NAME

---------- ---------- -------------------- -------------------- ------------------------------ --------------- ------------------------------

         2         17 CCMETL               CCMETL               TRA_CSG_HSE_BASE               Row-X (SX)      oracle

SQL>  select * from gv$locked_object;

   INST_ID     XIDUSN    XIDSLOT     XIDSQN  OBJECT_ID SESSION_ID ORACLE_USERNAME                OS_USER_NAME                   PROCESS                  LOCKED_MODE

---------- ---------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ------------------------ -----------

         2         86          5         70     134281         17 CCMETL                         oracle                         9575                      ##########

SQL> select sid,serial#,inst_id ,username,sql_id from gv$session where sid=17 and USERNAME='CCMETL';

       SID    SERIAL#    INST_ID USERNAME                       SQL_ID