Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pinning stored procedures automatically
Can you explain how the startup procedure. Is there a best way to do this?
markp7832_at_my-deja.com wrote:
> 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 Fri Jul 16 1999 - 11:04:35 CDT