Other Oracle database topics

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

pinning objects

bigToe

2005-09-23, 9:23 am

If I pin a package, modify it & re-compile, what is the status of the
pinned package? Does it become unkept automatically?

Mark D Powell

2005-09-23, 11:23 am

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 --

Sponsored Links