From MohanR@STARS-SMI.com Tue, 06 Feb 2001 10:39:05 -0800
From: "Mohan, Ross" <MohanR@STARS-SMI.com>
Date: Tue, 06 Feb 2001 10:39:05 -0800
Subject: RE: Pinning Tables
Message-ID: <F001.002AC375.20010206085557@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: 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@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@fatcity.com 
    [mailto:root@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@dulcian.com">mailto:kevin@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@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@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@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).