go to metablink and search for PIND, and then modify it for your use. Steve
Adams also has a useful script on his site.
Raj
On 7/13/05, Schauss, Peter <peter.schauss_at_ngc.com> wrote:
>
> Oracle 8.1.7.4 <http://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
>
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 13 2005 - 13:00:46 CDT
