Re: Q:Keeping a table in memory for speed

In article <336A6195.1BBC_at_citicorp.com>,

   Simon Spencer <Simon.Spencer_at_citicorp.com> wrote:
>I dont suppose anyone can tell me how to make a table or group of tables
>memory resident?
>
>(Oracle 7.3, Under NT 4.0)

Well, in fact it's quite easy: you only need tables to be memory-resident if they're heavily used. Oracle will automatically keep those tables in memory.

Exception to this are tables accessed by a full table scan, they will be put at the LRU side of the cache-list and therefore will age out of the cache quickly. You can force Oracle to put a table accessed by a full table scan at the MRU side of the cache list by creating the table using the "cache" option, or specifying the cache hint in your queries. This is most useful for small reference tables, since small tables are always accessed by a full table scan.

If this is not what you want, you could create a second database, put the tables you want in memory in that database, assign enough memory to it to cache all tables and access them via a database link.

Hope this helps,

Stefan Deisz.

Name      :G.R.S. Deisz
Phone     :+31-50-5855954
E mail    :G.R.S.Deisz_at_PTT-Telecom.Unisource.NL
DISCLAIMER:This statement is not an official statement from, nor
           does it represent an official position of, PTT Telecom BV.