List of unreferenced objects
You need to query DBA_DEPENDENCIES.   But be aware of references that may exist outside of the database itself - references in sql scripts on some user's workstation, or in application code that is not a stored procedure.