| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> pinning packages
I am running Oracle 7.1.6 and using dbms_shared_pool.keep to pin packages. My question is do I really need to compile the package (load into memory) before executing the dbms_shared_pool.keep procedure. By just pinning the package without loading it first, the v$db_object_cache.kept shows it is pinned. The only difference is the shared_memory value is smaller than if I compile the package first.
Grace Received on Sat Apr 19 1997 - 00:00:00 CDT
![]() |
![]() |