Re: Pinning Packages in the Shared Pool

TCook_at_vtrlmel1.trl.oz.au (Tony Cook) writes:
:
: Has anyone successfully pinned a package into the shared pool ?
:
: It is mentioned briefly in the documentation, but does not outline how to do it.
: I did find the dbms_shared_pool package supplied by Oracle though.
: (Very little documentation on this)
: It has a procedure called "keep" that should do the job but I cannot get it to work.
:
: Example follows:
:
: 16:15:54 SQL+> begin
: 16:15:54 2 dbms_shared_pool.keep('HUSD2.PG_SEC_ADMIN');
: 16:15:54 3 end;
: 16:15:54 4 /
: begin
: *
: ERROR at line 1:
: ORA-06564: object HUSD2.PG_SEC_ADMIN does not exist
: ORA-06512: at "SYS.DBMS_UTILITY", line 28
: ORA-06512: at "SYS.DBMS_SHARED_POOL", line 17
: ORA-06512: at "SYS.DBMS_SHARED_POOL", line 24
: ORA-06512: at line 2
:
:
: For some reason my package cannot be found.
: I have tried a few permutations of running this as system or the package owner.
:
: Am I doing something wrong?
: Is there another way to pin objects?
:
: We are using 7.1.3 on HP-UX.
:
: Thanks
: Tony Cook

You must explicitly grant EXECUTE privilege to SYS on all of the packages you wish to pin in the shared pool.

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, World Wide Education, Oracle European Development Centre
Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+