Pin Objects in the Shared Pool

From Oracle FAQ

This article explains how to use the DBMS_SHARED_POOL package to manage the SHARED_POOL in the instance's SGA:

Contents 1 Install the DBMS_SHARED_POOL package 2 Check for objects in the Shared Pool larger than X KBytes 3 Pin something into the Shared Pool 4 Unpin something from the Shared Pool 5 Check what objects are pinned

Install the DBMS_SHARED_POOL package

connect SYS AS SYSDBA
@?/rdbms/admin/dbmspool.sql
@?/rdbms/admin/prvtpool.plb

Check for objects in the Shared Pool larger than X KBytes

set serveroutput on size 50000
exec dbms_shared_pool.sizes(200);

Pin something into the Shared Pool

exec dbms_shared_pool.keep('SYS.STANDARD');

Unpin something from the Shared Pool

exec dbms_shared_pool.unkeep('SYS.STANDARD');

Check what objects are pinned

SELECT * FROM v$db_object_cache WHERE kept = 'YES';

PS: Looks like Oracle pins some objects by itself.