Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pinning Packages Not Yet Loaded
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