Pinning Packages on the shared pool

From: Prabhu Krishnaswamy <prabhu_adam_at_hotmail.com>
Date: Thu, 24 Mar 2011 16:49:49 +0000
Message-ID: <BAY160-w588BA0E658102DAD45B47685B60_at_phx.gbl>


Lists,  

Our appliction team has requested (as per vendor's recommendations), to pin the frequently used packages (around 6 to 8 packages) on the shared pool. We thought of pinning the packages using the DB Startup trigger, so every time DB recyles, those packages gets included on the memory. Is there any other better way of handling this rather than using the startu trigger. Any advice is highly appreciated.  

Thank you,
Prabhu

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 24 2011 - 11:49:49 CDT

Original text of this message