[管理脚本] 数据库中的对象

break on owner skip 1
select
    owner,
    object_type,
    status,
    count(*) count#
from
    all_objects
group by
    owner,
    object_type,
    status
order by
    owner,
    object_type,
    status
/