Re: How to keep a table in memory? Oracle 10g

From: Charles Hooper <>
Date: Mon, 3 Mar 2008 13:17:49 -0800 (PST)
Message-ID: <>

On Mar 3, 1:23 pm, "Sam" <> wrote:
> Hi There,
> I have a table with heavy select queries on it, with almost no Insert or
> Update.
> Is there a way to make Oracle keep this table or a View of this table in
> memory(RAM)? for faster access?
> I have enough RAM on the system and tables are not that big,
> Any suggestions?
> I use:
> Oracle: 10g
> OS: Windows Server 2003
> Thank you in advanced

Investigate the KEEP buffer pool:

If the table is small compared to the amount of memory available for the default buffer cache, and the blocks are frequently accessed, Oracle will automatically keep the blocks in default buffer cache without you having to make any changes (such as setting up a KEEP cache and altering the table to use the KEEP cache [buffer pool]).

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Mar 03 2008 - 15:17:49 CST

Original text of this message