Hi

You can pin large sql packages using dbms_shared_pool.keep

regards
Hrishy