See what objects are pinned

SELECT SUBSTR (owner, 1, 10) owner, SUBSTR (TYPE, 1, 12) TYPE,
SUBSTR (NAME, 1, 20) NAME, executions, sharable_mem mem_used,
SUBSTR (kept || ' ', 1, 4) "Kept?"
FROM v$db_object_cache
WHERE TYPE IN ('TRIGGER', 'PROCEDURE', 'PACKAGE BODY', 'PACKAGE')
and owner <> 'SYS'
ORDER BY owner, executions DESC;