Re: Pinning a Table?

On 28 Sep 1998 05:22:16 GMT, netproinc2_at_aol.com (Netproinc2) wrote:

>
>Hi Chris,
>
>Oracle has the ability to cache tables into memory. This feature permits
>frequently accessed data to be pegged into the data buffer cache for
>fast access. Lookup code, static and small tables are all candiates for
>being cached. Table size should be under 100 Oracle blocks.
>
>CREATE TABLE ... cache;
>Data will be loaded into the data buffer cache after the first access.
>
>NOTE: Check on available memory in the SGA before starting to cache
>tables.
>
>Take Care,
>Ranga Reddy.
>Oracle DBA.

This is not quite correct. The cache option doesn't pin the data blocks. It simply tells Oracle to place the table at the most recently used end of the LRU chain. It then takes the blocks longer to age out.

Regards

Clive. Received on Wed Sep 30 1998 - 18:49:30 CDT