Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to pin a table in memory?
Thomas Dreßler <tdressler_at_primus-online.de> schrieb:
> 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.
This package is used to make shure that large packages are pinned in the library cache... not in the buffer cache.
You have to create (or alter) the table with the cache hint clause.
ALTER TABLE SCOTT.S_EMP CACHE; HTH, Kathinka Received on Tue Jul 11 2000 - 00:00:00 CDT