Friday, July 10, 2015

Is there a lock on any object/table ??

select a.session_id,a.oracle_username, a.os_user_name, b.owner "OBJECT OWNER", b.object_name,b.object_type,a.locked_mode from
(select object_id, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE from gv$locked_object) a,
(select object_id, owner, object_name,object_type from sys.dba_objects) b
where a.object_id=b.object_id
and b.object_name = ''

No comments:

Post a Comment