RE: Pinning Tables

If
it's frequently accessed, caching it will keep it there.
<FONT face=Arial color=#0000ff

size=2> 
if
it's big, it may may a splash in the buffer pool, so use the multiple pool features.
<FONT face=Arial color=#0000ff

size=2> 
"big"
and "small" are relative to size of buffer pools, of course.....
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>hth
 

  <FONT face="Times New Roman"
  size=2>-----Original Message-----From: Kevin Kostyszyn   [mailto:kevin_at_dulcian.com]Sent: Tuesday, February 06, 2001 9:11   AMTo: Multiple recipients of list ORACLE-LSubject: RE:   Pinning Tables
  <FONT face=Arial color=#0000ff
  size=2>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]     Sent: Monday, February 05, 2001 10:36 AM <FONT     size=2>To: Multiple recipients of list ORACLE-L <FONT     size=2>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? <FONT     size=2>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).