Re: ** cache table

  • From: A Joshi <ajoshi977@xxxxxxxxx>
  • To: ajoshi977@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 29 Nov 2006 07:32:20 -0800 (PST)

The oracle version is 8i and 9i. 
  Thanks Dennis and Thomas for your reply. 

A Joshi <ajoshi977@xxxxxxxxx> wrote:
    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

Want to start your own business? Learn how on Yahoo! Small Business.

Other related posts: