Re: pinning objects

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Sep 2005 07:48:48 -0700
Message-ID: <1127486927.983322.153580@g47g2000cwa.googlegroups.com>

bigtoe, if the package was kept to begin with via dbms_shared_pool.keep then the recompiled package is kept but a new version has been loaded. Also Oracle handles the pinning and unpinning of packages automatically so it is not something you do explicitly. While a package is in a pinned state it cannot be recompiled. While the package is being recompiled it cannot be executed. These operations are serialized by Oracle.

HTH -- Mark D Powell -- Received on Fri Sep 23 2005 - 09:48:48 CDT