Re: Forcing a table into memory
From: Arup Nanda <102234.1162_at_CompuServe.COM>
Date: 1996/04/17
Message-ID: <4l33bb$fpg$1_at_mhadf.production.compuserve.com>#1/1
Date: 1996/04/17
Message-ID: <4l33bb$fpg$1_at_mhadf.production.compuserve.com>#1/1
>>The table will stay in cache as long as it is being
used.<<
I'm sorry to point it out, bu the table does not stay in memory all the time it is used. Only data blocks that are accessed are stored in the Data buffers in System Global Area. When a large table is accessed, the data blocks are retrieved from the physical disk and then written into data buffers. When the data buffer is full, the "dirty" blocks are written into disk by DBWR.
There is a package DBMS_SHARED_POOL that has some procedures to pin some types of objects in shared pool all the time. However they support only packages, stored procedures and functions right now. I guess tables and views will be supported in future.
- Arup Nanda