Advanced Search

List locked object Oracle Database

/ Published in: SQL
Save to your folder(s)
List locked object Oracle Database using V$LOCKED_OBJECT view

Expand | Embed | Plain Text

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.