Re: How to keep a table in memory? Oracle 10g
Date: Mon, 3 Mar 2008 13:17:49 -0800 (PST)
On Mar 3, 1:23 pm, "Sam" <ysa..._at_yahoo.com> wrote:
> Hi There,
> I have a table with heavy select queries on it, with almost no Insert or
> 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 10.2.1.0
> 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]).
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Mar 03 2008 - 15:17:49 CST