Re: Preloading Packaged Prodedures

From: Carlos Augusto Leite Netto <cnetto_at_bestway.com.br>
Date: 1996/09/10
Message-ID: <3235351C.7E9E_at_bestway.com.br>#1/1

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

Received on Tue Sep 10 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Martin Malley: "Re: [Q] Duplicate a database and changing the SID"
Previous message: Marek Wiechula and Sheila Plant: "Re: connect userid/password script"
In reply to: Colin Bennett: "Preloading Packaged Prodedures"
In reply to Brian Martin: "Re: Preloading Packaged Prodedures"
Next in thread: Martin Malley: "Re: [Q] Duplicate a database and changing the SID"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message