Re: Pinning a Table?

From: Netproinc2 <netproinc2_at_aol.com>
Date: 28 Sep 1998 05:22:16 GMT
Message-ID: <19980928012216.14583.00002931@ng-fa2.aol.com>

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. Received on Mon Sep 28 1998 - 00:22:16 CDT