RE: Which packages to pin

Peter,

Wouldn't it be easier to just increase shared pool?

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Wednesday, July 13, 2005 1:45 PM
To: oracle-l_at_freelists.org
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
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 13 2005 - 12:50:14 CDT