select role from dba_roles where role like ‘%JAVA%’;
SELECT o.owner ,o.objects,NVL(i.invalids, 0) invalid
FROM (SELECT owner, count(*) objects
FROM dba_objects
WHERE object_type like ‘JAVA%’
GROUP by owner) o,
(SELECT owner, count(*) invalids
FROM dba_objects
WHERE object_type like ‘JAVA%’
AND status = ‘INVALID’
GROUP by owner) i
WHERE o.owner = i.owner(+);
