Oracle: Containers

select *
from
   dba_objects
where
   object_type = 'CONTAINER';