SQL> r 1* select owner,count(1) from dba_objects where object_name like '%/%' group by owner OWNER COUNT(1) ------------------------------------------------------------------------------------------ ---------- PUBLIC 15454 EXFSYS 42 SYS 15235
SQL> select object_type,count(1) from dba_objects where object_name like '%/%' group by object_type; OBJECT_TYPE COUNT(1) --------------------------------------------------------- ---------- JAVA RESOURCE 702 TABLE 3 JAVA CLASS 14558 SYNONYM 15454 TYPE 14