Re: Forcing a table into memory
Date: 1996/04/16
Message-ID: <31738C0C.3AE5_at_delphi.com>#1/1
Krister D. Ungerboeck wrote:
>
> Is it possible to force a table into memory and ensure that Oracle
> doesn't swap it out?
>
> Krister D. Ungerboeck
The table will stay in cache as long as it is being used. Cache will stay in physical memory if there is enough physical memory. If you are seeing swap-outs, you need more memory -- don't worry about the fine points of which tables are cached. One you have enough memory to avoid swap-outs, Oracle will cache the table will it is needed.
I have reason to believe they use a simple LRU algorithm to release blocks from cache which haven't been used recently. If you think this is a problem, increase cache.
You have a description of your tables in the shared SQL area. You have the data blocks in the db block buffer area. You may want to increase both.
-- S. Lott Consultant, NE Region CTG SLOTT_at_DELPHI.COM S.LOTT_at_CTG.COM 800-992-5350 box 7053Received on Tue Apr 16 1996 - 00:00:00 CEST