Re: Caching a table

Normally done dynamically. However, you an using "pinning" to keep it their.

My experience has been that if your tables are hit often enough that it makes sense to keep them in cache, the mru cache generally keeps it there anyways thus limiting the value of pinning.

Todd Verstraten
mailto:tverstrat_at_tier3.com
http://www.tier3.com

NORHISHAM BIN MAIN <med10054_at_leonis.nus.sg> wrote in article <58mrqj$r5l_at_nuscc.nus.sg>...
> Hi,
>
> Does Oracle supports caching an entire table in memory ? I have some
> small lookup tables which I would like to cache on instance startup
> to enhance performance.
>
> rgds,
> mars
>
  Received on Wed Dec 11 1996 - 00:00:00 CST