-- All PDBS except SEED
alter session set container=CDB$ROOT;
select con_id, status, count(*) from cdb_objects 
--where owner in ('SYS','SYSTEM') 
group by con_id, status order by con_id ;
select con_id, status, count(*) from cdb_objects 
where owner in ('SYS','SYSTEM') 
group by con_id, status order by con_id ;
--
-- SEED
alter session set container=PDB$SEED;
select con_id, status, count(*) from cdb_objects 
--where owner in ('SYS','SYSTEM') 
group by con_id, status order by con_id ;