Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: The Cache option
This is just so the table is not aged out. You might want to look at buffer pools.
Beldar wrote:
> The Cache option of the Create Table and Alter Table commands ensures that
> the first time a table is accessed, the entire table is loaded into the SGA
> and marked as 'most recently used'. According to Oracle doc, this data is
> still subject to LRU algorithms, yet stays in the SGA longer than normal.
> HOW? Isn't every block marked 'most recently used' when it's first
> accessed?
Received on Mon Apr 02 2001 - 06:59:29 CDT