Posted By

ceduard0 on 08/06/13


Tagged

object Oracle locked


Versions (?)

List locked object Oracle Database


 / Published in: SQL
 

List locked object Oracle Database using V$LOCKED_OBJECT view

  1. SELECT o.OBJECT_NAME, l.SESSION_ID, l.ORACLE_USERNAME, l.OS_USER_NAME, l.PROCESS
  2. FROM V$LOCKED_OBJECT l, USER_OBJECTS o
  3. WHERE o.OBJECT_ID = l.OBJECT_ID;

Report this snippet  

You need to login to post a comment.