Re: Pin a table in memory

Gillian Lezama <glezama_at_amoco.com> wrote in article <5c37fh$4d0_at_cronkite.amoco.com>...
> The main reason that it is not staying in the SGA is because it is being
 aged
> out due to lack of space. An object or data cannot be aged out if it
 being
> referenced frequently. So, why do you want the data in there it is not
 being
> referenced continuously?

Sometimes when you want something, you want it *now*. The ability to pin a table in cache is very much a performance technique. You have to consider the architecture of the application in question before you can determine the usefulness of pinning a table.

The syntax for this is:

ALTER TABLE tablename CACHE;

To 'unpin' the table, do:

ALTER TABLE tablename NOCACHE;

Pretty simple, actually. Received on Tue Jan 28 1997 - 00:00:00 CST