Re: pinning tables into memoty? Help!!!

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 17 Jan 2001 16:54:20 +0000
Message-ID: <3A65CE3C.6A4AF0BA_at_rdbms.freeserve.co.uk>


Serge,

Try using the CACHE keyword in CREATE TABLE or ALTER TABLE. It specifies that the data will be accessed frequently, therefore its blocks are placed at the most recently used end of the LRU list.

Chris
Serge Nantel wrote:
>
> Hi all
>
> Somme one knowg how to load specifique tables into memory Oracle 8.0.5
>
> Thank all
Received on Wed Jan 17 2001 - 17:54:20 CET

Original text of this message