A cached table will be loaded into the 'most frequently accesses data'
end of the SGA data buffers upon the first time that a FULL TABLE SCAN is
done on the table. This is not a guarantee that the data will stay in
the buffers forever, but significantly improves its chances of being
there when you need it. typically the small reference tables are
frequently accessed so would tend to stay in memory once loaded by the
table scan.
--
R. Wayne Linton, I.S.P.
Database & Systems Management
Shell Canada Ltd.
Received on Thu Jan 30 1997 - 00:00:00 CST
