Path: text.usenetserver.com!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news3.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Mon, 03 Mar 2008 11:15:30 -0800 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: Can we keep a table in memeory for faster access? Oracle 10g References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1204571728.710388@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@dsl-216-162-218-178.drizzle.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 27 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.misc:251999 X-Received-Date: Mon, 03 Mar 2008 14:15:29 EST (text.usenetserver.com) 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 > > > > Thank you in advanced http://www.psoug.org/reference/tables.html Look up entries related to CACHE and POOL. -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org