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: Seeing what's pinned in the shared pool

Re: Seeing what's pinned in the shared pool

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: 1997/07/14
Message-ID: <33cab930.2983286@newshost.interact.net.au>#1/1 







On Sun, 13 Jul 1997 23:53:28 -0600, Wayne Linton
<lintonw_at_cadvision.com> wrote:



>have a look at view V$DB_OBJECT_CACHE.  In ORACLE7 V7.1 and later there

>is a field that indicates if the package is pinned.  

>

>Wayne Linton

>Shell Canada Ltd.





Thanks Wayne, that was exactly what I was after.



Happy hacking


Fuzzy


:-)
Received on Mon Jul 14 1997 - 00:00:00 CDT












Original text of this message













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