v$sql_shared_memory

chunk_com, structure, function

structure || case when structure is not null then ' : ' end || function

select
   count(*),
   structure,
   function
from
   v$sql_shared_memory
group by
   structure,
   function
order by
   structure,
   function;

See also