Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** cache table
The oracle version is 8i and 9i.
Thanks Dennis and Thomas for your reply.
A Joshi <ajoshi977_at_yahoo.com> wrote:
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.
Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 29 2006 - 09:32:20 CST
![]() |
![]() |