Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to pin a table in memory?

Re: How to pin a table in memory?

From: Kathinka Diehl <kathinka_at_rrr.de>
Date: 2000/07/11
Message-ID: <8kf3lr$2b5ea$1@ID-6887.news.cis.dfn.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US