1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

table locked during transaction

Discussion in 'SQL PL/SQL' started by laxman, Mar 23, 2010.

  1. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Hi all,
    i am facing some problem while transaction occur between client application and oracle database,after some time one message is coming such as 'Transaction did not completed in time' ,it seems table are getting locked automatically.i don't know why it is happening .

    with query i have verifed that table are get locked

    Code (SQL):
    sql>SELECT sid, serial# ,b.LOCKED_MODE, object_name, machine FROM user_objects a, v$locked_object b, v$session c WHERE a.object_id = b.object_id AND b.session_id = c.sid
    then again i need to kill the session with following query

    Code (SQL):
    sql>sys.dba_sudo_session.kill_session('589', '43319');
    Kindly provide me any solution

    Regards
    Laxman
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Since we don't know what this other session is doing we can't offer any advice. Post the sessions and what they are doing when this occurrs; tables don't get locked automatically without some transaction running against them.