** cache table
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 27 Nov 2006 18:23:49 -0800 (PST)
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
Other related posts:
