RE: Pinning packages

There was once that I pinned a package. It was large and somewhat frequently used by customer service....in a database with VERY high-activity. It would take 5-10 seconds to load the first time. After that, run times would be in the 1-2 second range. About 20 times a day it was aged out. Customer service complained about run-times until I pinned the package in memory. then the complaints went away....

The lession, don't do it unless there is a specific need.

Kevin

-----Original Message-----
From: Tanel Poder [mailto:tanel.poder.003_at_mail.ee] Sent: Wednesday, July 23, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Pinning packages

Hi!

I've never pinned anything unless I've had serious trouble in shared pool (fragmentation, ORA-4031's, latch contention etc..) And pinning has usually been one of the last resorts, because Oracle manages shared pool contents fine if your application is well written, you are using decent Oracle version and shared pool is sized reasonably...)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 23, 2003 10:19 PM

> Hi
>
> My question is to all the 8i dba's.
> Do you still pin packages in memory. ??? If you do what is the reason for
it??
> I am referring to both system packages and application packages.
>
> TIA
> Yuval.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arnon, Yuval
> INET: Yuval.Arnon_at_webloyalty.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).