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: What is an Oracle pin?

Re: What is an Oracle pin?

From: <remove.rdfield_at_ibm.net>
Date: Wed, 13 Jan 1999 17:38:45 +0000
Message-ID: <369CDA25.981F92C4@ibm.net>


To pin a piece of PL/SQL issue the command execute dbms_shared_pool.keep(<package name>)

when this completes, the named package can't be aged out of the shared pool
(i.e. it's 'pinned' there)

Raymond Field

Paul wrote:

> What is an Oracle pin?
>
> Paul
> aspscott_at_tcp.co.uk
> ^^ remove 'as' anti spam prefix to reply
Received on Wed Jan 13 1999 - 11:38:45 CST

Original text of this message

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