Database - RAC/Scalability (MOSC)

MOSC Banner

Can anyone help on this?

edited Sep 23, 2015 10:01AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center