Re: Pinning Packages Not Yet Loaded

Your assumption is correct.
Actually in 8i you could do this with an on-startup trigger.

Hth,

Sybrand Bakker, Oracle DBA

"Ethan Post" <epost1_at_my-deja.com> wrote in message news:8jilvh$idu$1_at_nnrp1.deja.com...
> 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.
Received on Fri Jun 30 2000 - 00:00:00 CDT