Re: How to pin a table in memory?

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/07/12
Message-ID: <396c41bb@news.iprimus.com.au>#1/1

The cache clause makes zero difference in the long run.

Interesting that since year zero the Oracle training materials have suggested you should 'use the CACHE clause for small, frequently used tables'. To which the obvious rejoinder is.... if the table is frequently used, where do you think the blocks from it are likely to be in any case??

Short answer: it's a complete red herring, and a waste of time.

Regards
HJR <Pebibit_at_pebibit.com> wrote in message news:396B214D.631785C4_at_pebibit.com...
> look at http://www.oracle.com/oramag/oracle/00-May/o30tun.html
> ALTER TABLE [TABLENAME] CACHE;
>
>
>
> CU
> pebibit_at_pebibit.com
>
> "Thomas Dreßler" wrote:
>
> > 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
>
Received on Wed Jul 12 2000 - 00:00:00 CDT