##  Pinning stored database packages into the shared SQL pool

    Package dbms_shared_pool is
      procedure Keep (pkg_name varchar2);
    End;

    sql >> execute dbms_shared_pool.keep (‘scott.GL_package’);



    Package GL_Package is
       Load_Me   number;
       procedure ABC;
       ...
    End;
    Package AP_Package is
       Load_Me   number;
       procedure MNO;
       ...
    End;
    Package AR_Package is
       Load_Me   number;
       procedure XYZ;
       ...
    End;


    sql >> execute scott.GL_package.Load_Me := 0;
    sql >> execute dbms_shared_pool.keep (‘scott.GL_package’);

    sql >> execute scott.AP_package.Load_Me := 0;
    sql >> execute dbms_shared_pool.keep (‘scott.AP_package’);

    sql >> execute scott.AR_package.Load_Me := 0;
    sql >> execute dbms_shared_pool.keep (‘scott.AR_package’);