Re: Preloading Packaged Prodedures

Carlos Augusto Leite Netto wrote:
>
> Colin Bennett wrote:
> >
> > Does anyone out there know if it is possible to preload packages
> > at database startup time ?.
> >
> > --
> > When all you have is a hammer, every problem looks like a nail
>
> Preload.... humm. If you mean loading the procedures into the shared
> pool to speed up the first execution, YES. It's possible.
>
> Just look for the procedure keep in the packages inside rdbms/admin.
> There is one procedure for glueing packages in the shared pool. You
> should also execute it for pre-loading. Keep you make sure that the
> package will remain there.
>
> Regards,
> --
> Name: Carlos Netto e-mail: cnetto_at_softdes.com.br
> Software Design Informatica Oracle System Integrator
> Oracle BAP member. Softex/2000 member. Campinas, Sao Paulo, Brazil

execute DBMS_SHARED_POOL.KEEP('object_name_you_wnated'); This may not preload, but pins in the shared pool and exclude from LRU list.

• Joseph Suh dbtech_at_inetnow.net.usa *
• Oracle DBA 770-908-9785 *
• Database Technology Int'l, Inc. *
• Atlanta, Georgia *

  ---