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 ----- From: "Arnon, Yuval" <Yuval.Arnon_at_webloyalty.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 23, 2003 10:19 PM Subject: Pinning packages

> 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).
Received on Wed Jul 23 2003 - 13:49:16 CDT