Status von Oracle Objekten anzeigen

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;