Re: Can we keep a table in memeory for faster access? Oracle 10g
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 03 Mar 2008 21:28:45 +0100
Message-ID: <6335btF25o5jqU1@mid.individual.net>
>> 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 10.2.1.0
>> OS: Windows Server 2003
Date: Mon, 03 Mar 2008 21:28:45 +0100
Message-ID: <6335btF25o5jqU1@mid.individual.net>
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 10.2.1.0
>> OS: Windows Server 2003
> http://www.psoug.org/reference/tables.html > > 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