Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ** cache table

** cache table

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Mon, 27 Nov 2006 18:23:49 -0800 (PST)
Message-ID: <20061128022350.70318.qmail@web58008.mail.re3.yahoo.com>


Hi,

    For cache of table : does it need to be specified at CREATE TABLE stage only. Also does cache mean it will stay in memory forever (like PIn/KEEP of PL/SQL in shared Pool) or is there a case when it will get aged out. Thanks for your help. Yes. there is an option with : ALTER TABLE xxxx CACHE. However below is what documentation says :    

  CACHE | NOCACHE Use the CACHE clauses to indicate how Oracle should store blocks in the buffer cache. If you specify neither CACHE nor NOCACHE:     

   In a CREATE TABLE statement, NOCACHE is the default    In an ALTER TABLE statement, the existing value is not changed.  



Sponsored Link

   Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms
--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 27 2006 - 20:23:49 CST

Original text of this message

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