Pinning Packages on the shared pool
- From: Prabhu Krishnaswamy <prabhu_adam@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Mar 2011 16:49:49 +0000
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
Other related posts:
