试下这个sql

select owner,count(1)  from all_objects  group by owner

select
        ur.name,
        sch.name
from
        sysobjects sch,
        sysobjects ur
where
        ur.subtype$='USER'
    and sch.type$  ='SCH'
    and ur.name not like 'SYS%'
    and sch.pid=ur.id order by 1;

这个sql可以查看所有的用户以及每个用户对应的schema