The Cache option

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 Sun Apr 01 2001 - 10:32:47 CDT