List locked object Oracle Database


/ Published in: SQL
Save to your folder(s)

List locked object Oracle Database using V$LOCKED_OBJECT view


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.