Re: Can we keep a table in memeory for faster access? Oracle 10g
From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 03 Mar 2008 11:15:30 -0800
Message-ID: <1204571728.710388@bubbleator.drizzle.com>
Date: Mon, 03 Mar 2008 11:15:30 -0800
Message-ID: <1204571728.710388@bubbleator.drizzle.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_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Mar 03 2008 - 13:15:30 CST