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>
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-lReceived on Thu Mar 24 2011 - 11:49:49 CDT