Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pinning stored procedures automatically

Re: Pinning stored procedures automatically

From: Robert Keller <rlkeller_at_yahoo.com>
Date: Fri, 16 Jul 1999 11:04:35 -0500
Message-ID: <378F5812.EF6EBEF6@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US