SELECT O.OBJECT_NAME
, O.OBJECT_TYPE
, O.STATUS
, O.LAST_DDL_TIME
, O.OBJECT_ID
, NVL(D.DEBUGINFO, 'F') DEBUGINFO
FROM SYS.DBA_OBJECTS O
, SYS.ALL_PROBE_OBJECTS D
WHERE O.OWNER = 'USER'
AND O.OBJECT_TYPE = 'SYNONYM'
AND O.OBJECT_ID = D.OBJECT_ID (+)
AND O.OBJECT_NAME = D.OBJECT_NAME (+)
AND O.OBJECT_TYPE = D.OBJECT_TYPE (+)
AND D.OWNER (+) = 'USER'
ORDER BY O.OBJECT_TYPE
, O.OBJECT_NAME
