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!

Oracle Find User Locking the Row of Table

Discussion in 'SQL PL/SQL' started by aymebinggung, Mar 11, 2011.

  1. aymebinggung

    aymebinggung Guest

    Hai I'm new in the RDBMS (Oracle).
    Anybody out there knows how to find out the username that locks a particular row in a number of tables in the Database?
    Is there a script to find that out? Such as what is what is the USERNAME, Session Id, Process Id, and Object Name?

    A script to find this out is much appreciated.
  2. rajavu

    rajavu Forum Guru

    Likes Received:
    Trophy Points:
    @ Bangalore , India

    Are you looking for this ?