Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pinning stored procedures automatically
In article <378DB8F6.39729EC2_at_synergy-infotech.com>,
Anurag Minocha <anurag_at_synergy-infotech.com> wrote:
> Hi,
> I have pinned some stored procedures in the database cache. Will they
be
> there in the cache the next time i restart my database .I no how do i
> autonate this so that next time whemn i restart my database it should
> automatically pin the stored procedures in the database. I am using
> oracle 8.0.5 on NT.
>
> anurag
>
> reply at
> anurag_at_synergy-infotech.com
>
>
When your restart Oracle your pinning will be lost. You can modify
your startup procedute to execute a pin script so when the system boots
you can re-establish your packages in the SGA.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 15 1999 - 08:54:31 CDT