Re: How to keep a table in memory? Oracle 10g

From: Pete <pmussomeli_at_gmail.com>
Date: Mon, 3 Mar 2008 15:16:35 -0800 (PST)
Message-ID: <5af4fa26-e3e4-4429-bd50-23c78cc95a19@h11g2000prf.googlegroups.com>


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
> 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

you don't really need to do this if your large pool parameter is set appropriately, but if you must, check out dbms_shared_pool.keep(<object>,<type>);. Received on Mon Mar 03 2008 - 17:16:35 CST

Original text of this message