Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table that exists only in memory
You may try altering your table to a CACHE table
alter table <table_name> cache;
tables marked as CACHE will be kept in the SGA longer. They're put in Most
recently used
blocks even if they're accessed via full table scans.
Alternatively, you can use HINTS in your SQL to cache tables.
You only want to do this with small tables (what's a small table?).
John
Jonathan Gennick <gennick_at_worldnet.att.net> wrote in article
<3692deaa.1824529_at_netnews.worldnet.att.net>...
> On Sun, 03 Jan 1999 05:07:19 GMT, robertch_at_mindspring.com
> (Robert Chung) wrote:
>
> >I need a table that does not interact with hard disk but is stored
> >only in memory for performance boost. I will be modifying this table
> >big time, but never commit.
>
> I don't think that Oracle supports any type of "in memory"
> table. Have you thought about using a package together with
> PL/SQL tables? Package variables are persistant, and you can
> pin a package in memory. PL/SQL tables give you array-like
> access to data. Will that work for what you are doing? Let
> me know. I can help you more if you like.
>
> Jonathan
>
Received on Mon Jan 04 1999 - 07:54:01 CST