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

From: Sam <>
Date: Mon, 3 Mar 2008 10:26:19 -0800
Message-ID: <fqhfnl$qp2$>

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 Received on Mon Mar 03 2008 - 12:26:19 CST

Original text of this message