Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: The Cache option

Re: The Cache option

From: David Busby <dbusby3_at_slb.com>
Date: Mon, 02 Apr 2001 06:59:29 -0500
Message-ID: <3AC869A1.B4FA80E0@slb.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US