Database Administration (MOSC)

MOSC Banner

lock on table by inactive session

edited Oct 17, 2013 9:50AM in Database Administration (MOSC) 9 commentsAnswered
One of the programs is inserting & committing into GTT and it was working fine since yesterday.
What is happening now is, the session status is inactive, transaction status is active and it holds row exclusive lock on the GTT and the shell script seems to hang

when I check frm the database, this is what is happening

select * from v$locked_object;

    XIDUSN    XIDSLOT      XIDSQN  OBJECT_ID SESSION_ID ORACLE_USERNAME              OS_USER_NAME             PROCESS
---------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ------------------------
LOCKED_MODE
-----------
    60       28      455888     285231        43 CUSTOM                  devuser            3794
      3


Session and Process Information
------------------------------

    SID             : 43
    Serial Number        : 75
    Oracle User Name        : CUSTOM

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