DBMS_SHARED_POOL.SIZES

dbms_shared_pool.sizes(N) shows objects that occupy more than N kb memory in the shared pool.

This procedure prints the values using dbms_output. Thus, when using the procedure in SQL*Plus, output must be enabled with set serveroutput on.

An educated guess is that sizes selects from v$db_object_cache and v$sqlarea.

set serveroutput on
begin
   sys.dbms_shared_pool.sizes(1000);
end;
/