RE: cached tables

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sun, 30 Sep 2001 02:15:28 -0700
Message-ID: <F001.0039CC9C.20010930021517@fatcity.com>

<FONT

  color=#0000ff face=Arial size=2>Just by executing the command   

<FONT

  color=#0000ff face=Arial size=2>alter table xxx cache   ;
<FONT color=#0000ff

  face="Arial TUR" size=2>Table won't come in cache. You have to select rows   from the table to get itinto
  cache.        Another point is that
  kept field is meant for pl/sql packages and functionsand not for objects   like tables/indexes etc. Below is full details of objectsa<SPAN   class=665035108-30092001>nd their codes that can be kept on database   startup.
   
<FONT

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

  --        
  Value        Kind of Object to 
  keep  --        
  -----        
  ----------------------  --       

  P         
  package/procedure/function  --      

  Q          sequence  
  --       
  R          trigger  
  --       
  T          type  
  --       JS         

  java source 
  --       JC        
  java class  --      

  JR         java resource  
  --       
  JD         java shared data  
  --       
  C          

  cursor
<FONT

  size=2><FONT color=#0000ff
  face=Arial>    So just run the command , select * from xxx ;   and select * from yyy, and finally
<FONT color=#0000ff

  face="Arial TUR" size=2>check after long   time to verify that only xxx is in cache and yyy is flushed out   from 
<FONT color=#0000ff

  face="Arial TUR" size=2><SPAN
  class=665035108-30092001>cache. 
<FONT color=#0000ff

  face="Arial TUR" size=2>      

<FONT color=#0000ff

  face="Arial TUR" size=2>Of
  course for verifying you can use,
<FONT color=#0000ff

  face="Arial TUR" size=2><SPAN
  class=665035108-30092001> 
<FONT color=#0000ff

  face="Arial TUR" size=2>select name, owner from   v$db_object_cache where name in ( 'xxx', 'yyy') ;
<FONT color=#0000ff

  face="Arial TUR" size=2><SPAN
  class=665035108-30092001> 
<FONT color=#0000ff

  face="Arial TUR" size=2><SPAN
class=665035108-30092001>HTH,
<FONT color=#0000ff

  face="Arial TUR" size=2><SPAN
  class=665035108-30092001>Rajesh
<FONT

  size=2>-----Original
  Message-----From: root_at_fatcity.com [mailto:root_at_fatcity.com]On   Behalf Of Bunyamin K. KaradenizSent: Saturday, September 29,   2001 10:55 PMTo: Multiple recipients of list   ORACLE-LSubject: cached tables   

  I execute
  alter table xxx cache ;
  But can not see this cached table on the query   below. Why ? Do you have any idea.?
  SELECT name, type, kept
  FROM v$db_object_cache
  WHERE
kept='YES'; Received on Sun Sep 30 2001 - 04:15:28 CDT