Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news4.google.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Robert Klemme Newsgroups: comp.databases.oracle.misc Subject: Re: Can we keep a table in memeory for faster access? Oracle 10g Date: Mon, 03 Mar 2008 21:28:45 +0100 Lines: 25 Message-ID: <6335btF25o5jqU1@mid.individual.net> References: <1204571728.710388@bubbleator.drizzle.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net qbGCGiNyxn9DnCB8LfMCuQt1wAFtgAdXSwia8vbResPbTEwk0= Cancel-Lock: sha1:1LpLmMUe9AZ5cQCDwKCZV9HW3ls= User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) In-Reply-To: <1204571728.710388@bubbleator.drizzle.com> Xref: usenetserver.com comp.databases.oracle.misc:252000 X-Received-Date: Mon, 03 Mar 2008 15:28:46 EST (text.usenetserver.com) 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