RE: Which packages to pin
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <peter.schauss@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Jul 2005 13:46:47 -0400
Peter,
Wouldn't it be easier to just increase shared pool?
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Schauss, Peter
Sent: Wednesday, July 13, 2005 1:45 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Which packages to pin
Oracle 8.1.7.4 - Aix 5.2.
As a cure for the ORA-4031 errors which we are getting (up to 5 per
day), I am looking at the possibility of pinning some of my stored
procedures and triggers. Looking at the Toad Pinned Code screen
combined with what I know about the application gives me a good idea of
what parts of the application code should be pinned, but I do have some
questions:
1. Are triggers normally candidates for pinning? (Toad lists them on
its screen, so I infer that they are.)
2. Should I also pin some of the system packages which are displayed on
the Toad Pinned Code screen? (e.g. DBMS_OUTPUT, STANDARD,
DBMS_STANDARD, DBMS_SQL...)
3. Which of the dynamic views (V$... ) lists the packages, stored
procedures, and triggers currently in the shared pool?
Thanks,
Peter Schauss
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
