Oracle Query to find locks on a database

SELECT OBJECT_NAME,OBJECT_TYPE,SESSION_ID,TYPE,LMODE,REQUEST,BLOCK,CTIME
FROM  V$LOCKED_OBJECT, ALL_OBJECTS, V$LOCK
WHERE
  V$LOCKED_OBJECT.OBJECT_ID = ALL_OBJECTS.OBJECT_ID AND
  V$LOCK.ID1 = ALL_OBJECTS.OBJECT_ID AND
  V$LOCK.SID = V$LOCKED_OBJECT.SESSION_ID
ORDER BY
  SESSION_ID, CTIME DESC, OBJECT_NAME;