Oracle: X$KQLSET

select
   inst_id,
   kglnaown    owner,
   kglnaobj    name,
   kglobtyp    type,
   kqlfshpn    heap_num,
   kqlfscid    cache_id,
   kqlfsscc    cache_cnt,
   kqlfsesp    heap_size,
   kqlfsasp    heap_alloc,
   kqlfsusp    heap_used,
   con_id
from
   x$kqlset;

select
   count(*),
   kglnaobj  name
from
   x$kqlset
group by
   kglnaobj
order by
   name;