Can we keep a table in memeory for faster access? Oracle 10g
From: Sam <ysasan_at_yahoo.com>
Date: Mon, 3 Mar 2008 10:26:19 -0800
Message-ID: <fqhfnl$qp2$1@utornnr1pp.grouptelecom.net>
Date: Mon, 3 Mar 2008 10:26:19 -0800
Message-ID: <fqhfnl$qp2$1@utornnr1pp.grouptelecom.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
Thank you in advanced Received on Mon Mar 03 2008 - 12:26:19 CST