Re: Use of CACHE parameter.

Hi,

the syntax is 'alter table <table_name> cache'.

It does not hoveveer load entire tables into memory. It just will place the result of a full table scan first in the LRU list rather than last as it normally does. This means that blocks retreived through a full table scan will be threated the same way as data retrived through an index scan would do.

Do not use this setting for large table as it might flush your entire buffer cache.

Rgds
Steinar Heggelund

Petter Harnes (Petter.Harnes_at_teleplan.no) wrote:
: From Oracle DBA Handbook by Kevin Loney:
 

: "Another option for memoty management will become available with 7.1. This
: option, called CACHE, will automatically load an entire table into the SGA
: the first time tat table is accessed."
 

: How to use this parameter is however not covered. I cannot find any
: information about the parameter in my documentation. Basicly my problem is:
: 1) Where to set the parameter.
: 2) The syntax of the setting.
 

: I'm using 7.2 for NT.
 

: --
: Petter Harnes
: Norconsult Telematics, Norway
: Email: Petter.Harnes_at_teleplan.no
Received on Wed Mar 19 1997 - 00:00:00 CET