Folgender Befehl zeigt den Status von Datenbankobjekten in Oracle an.
1: SELECT DISTINCT (object_type) object,
2: status,
3: OBJECT_NAME,
4: COUNT(*)
5: FROM user_objects
6: GROUP BY object_type,
7: status,
8: object_name
9: ORDER BY status ASC;