Use of CACHE parameter.
From: Petter Harnes <Petter.Harnes_at_teleplan.no>
Date: 1997/03/10
Message-ID: <01bc2d53$cd6e1390$3a1919ac_at_kd8qg>#1/1
Date: 1997/03/10
Message-ID: <01bc2d53$cd6e1390$3a1919ac_at_kd8qg>#1/1
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.noReceived on Mon Mar 10 1997 - 00:00:00 CET