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

Home -> Community -> Usenet -> c.d.o.misc -> Shared Memory - Pinning a procedure

Shared Memory - Pinning a procedure

From: Jay <gjay_at_erols.com>
Date: Fri, 23 Oct 1998 14:36:48 -0400
Message-ID: <70qid4$pnn$1@autumn.news.rcn.net> 





What happens?


When a stored procedure is pinned in ORACLE Shared Pool
by execute dbms_shared_pool.keep('ProcedureName')
and it is not unpinned by a statement UNKEEP



Subsequently if a new segment is added to the Stored Procedure and executed.



What happens to the pinned code? and the new code?



Any details can be appreciated.



Thanks.



Received on Fri Oct 23 1998 - 13:36:48 CDT












Original text of this message













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