SET LINESIZE 160


SELECT SESSION_ID,ORACLE_USERNAME,OS_USER_NAME,OWNER,OBJECT_NAME
FROM GV$LOCKED_OBJECT L,DBA_OBJECTS O
WHERE L.OBJECT_ID=O.OBJECT_ID;