Re: How to pin a table in memory?

In Oracle7, there is no way to pin a table in memory but you can use "alter table <table name> cache;" which places all the retrieved blocks in the most recently used end of the LRU list in the buffer cache when a full table scan is performed.

With Oracle8i, you can use :
"alter table <table name> storage (buffer_pool keep);" which retains the table blocks in memory. You have to set the init parameters:
db_block_buffers, db_block_lru_latches and buffer_pool_keep to use the "keep buffer".

--
Have a nice day
Michel


Thomas Dreßler <tdressler_at_primus-online.de> a écrit dans le message : 396b0ad8_at_news.ivm.net...


> Hallo,

> can anyone tell me, how to fix a table in memory?

> DBMS_SHARED_POOL can only keep packages, triggers und procedures and the

> CACHE parameter does'nt it.

> Thomas

>

>