Re: Q: storig frequently used tables into memory?

From: Sanjay D.S. <sanjay_at_fsg.prusec.com>
Date: 1996/03/19
Message-ID: <4imeok$fj8_at_prufire4.prusec.com>#1/1

Yes, It is possible to store (cache) table data into SGA. This is supported by ORACLE7.1 and above. You can create table with parameter CACHE, thus whenever
this table is queried all the rows in the table get cached, irrespective of number of rows fetched by the query. Can be quiet useful for common lookup tables in your application.

sanjay d.s.

Received on Tue Mar 19 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: ASRAJU: "Running reports in batch mode - question???"
Previous message: Thomas J Kyte: "Re: Q: storig frequently used tables into memory?"
Maybe in reply to: Marc PETERS - Groupe ICC: "Q: storig frequently used tables into memory?"
Next in thread: Aaron Goldman: "Re: SQLPLUS QUESTION - list tables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message