Shared pool loaded objects

You can find the loaded objects (packages, views etc) currently in the Shared Pool with the query:

SELECT OWNER, NAME, TYPE, ROUND(SHARABLE_MEM/1024,2) SIZE_KB, LOADS, KEPT, EXECUTIONS, LOCKS, PINS 
FROM V$DB_OBJECT_CACHE 
WHERE TYPE IN ('PROCEDURE', 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'TRIGGER', 'VIEW') 
-- AND NAME LIKE '%IGS_FI_F_CAT_FEE_LBL_SCA_V%'
ORDER BY SHARABLE_MEM DESC;

Tip: You can empty the contents of shared pool with the command: 

alter system flush shared_pool;