Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pinning Packages Not Yet Loaded

Re: Pinning Packages Not Yet Loaded

From: <eshevtsov_at_my-deja.com>
Date: 2000/06/30
Message-ID: <8jis9g$nnj$1@nnrp1.deja.com>#1/1

Hi

According to Garry&Corrigan the best practice before pinning a package to load it using dummy package variable immediately after startup a database.

Kind regards,
Edward

In article <8jilvh$idu$1_at_nnrp1.deja.com>,   Ethan Post <epost1_at_my-deja.com> wrote:
> My assumption is that the dbms_shared_pool.keep procedure should load
> it for you.
>
> -Ethan
> http://www.freetechnicaltraining.com
> http://www.gnumetrics.com
>
> In article <Gp475.4935$j7.261697_at_news.bc.tac.net>,
> "Jake de Haan" <jake_dehaan_at_telus.net> wrote:
> > Hi,
> >
> > I'm trying to figure out how best to pin a package in the shared
 pool
> > that is not yet been executed. I don't really want to execute any
> > function within the package (this is a application package) so the
> > real question is "how do I load a package into the shared pool so
 that
> > I can pin shortly after startup?"
> >
> > Jake.
> >
> >
>
> --
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US