v$sql_shared

chunk_com, structure, function

In many cases chunk_com is something like

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

(plus minus one or two whitespaces)

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