Re: Can we keep a table in memeory for faster access? Oracle 10g

From: Robert Klemme <>
Date: Mon, 03 Mar 2008 21:28:45 +0100
Message-ID: <>

On 03.03.2008 20:15, DA Morgan wrote:

> 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
> Look up entries related to CACHE and POOL.

Well, Oracle will cache tables anyway so it might not even be needed to pin a particular table in memory. Sam, why do you think you need to do this?

Kind regards

        robert Received on Mon Mar 03 2008 - 14:28:45 CST

Original text of this message