Pin a table in memory

"AC> From: "Tony A. Carey" <tcarey_at_ent.mrj.com>

"AC> To anyone who can help

"AC> Is there anyway to force rows of an oracle table to remain resident in
"AC> machine memory during the time in which the instance is running?

"AC> Regards,

"AC> Tony.

"AC> ---

Not really, although you can alter table ... cache. This places the blocks that are retrieved into the most recently used end of the LRU list, so they will likely stay in memory longer.

More explanation can be obtained by doing an altavista search on LRU +oracle.

Depending on what you are doing, you could put the values in a package and pin it in memory, too.

jg

--
Standard disclaimer: The views of this user are strictly his own.