RE: Pinning Tables

Sorry
about how late this reply is, we got hammered with 12 inches of snow yesterday.  Anyway, I guess I was thinking that "pinning" a table in memory would mean it is always there as opposed to caching where it might not be there all of the time.
<FONT face=Arial color=#0000ff
size=2>Kev

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Mohan, RossSent:   Monday, February 05, 2001 4:50 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: Pinning Tables
  What is the difference between table caching and "pinning", to   your thinking?
  -----Original Message----- From: Kevin   Kostyszyn [<A
  href="mailto:kevin_at_dulcian.com">mailto:kevin_at_dulcian.com] <FONT   size=2>Sent: Monday, February 05, 2001 10:36 AM To:   Multiple recipients of list ORACLE-L Subject: Pinning   Tables
  Hi all,        
  I have been trying to find some reference on pinning tables in   the SGA.  I haven't found anything, all that I am   finding is table caching and the keep buffer   pool.  Is this all that there is, can I "pin" a table in the   memory? Thanks in advance.
  Sincerely, Kevin Kostyszyn
  DBA Dulcian, Inc <FONT
  size=2>www.dulcian.com kevin_at_dulcian.com

• Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>-- Author: Kevin Kostyszyn <FONT size=2>  INET: kevin_at_dulcian.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT size=2>-------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).