Re: Cashing result set in RAM

Hi,

You can use the CACHE option on the CREATE / ALTER TABLE command, which means that the table is loaded into the MRU of the Oracle Buffer Cache.

Alternatively, you could configure your instance to have MULTIPLE BUFFER POOLS and define this table as using the KEEP buffer pool. For more information, have a read of Chapter 14 of the Oracle 8.0.5 Tuning Guide.

Rgds
Andrew

odessa7_at_my-dejanews.com wrote:

> We use Oracle 8.0.5 on NT and will switch to Lunix. We have a catalog table
> with 20,000 rows (2 columns: char(10), varchar2(1000)).
>
> The data is fairly static, but there will be big "select..like '%d%' "
> activity (1000++ request per minute). Looks like the indexes can't be used
> (because like starts with %).
>
> So, is there a way to cashe the whole table in RAM/buffer so that all select
> are executed there?
>
> Thanx
>
> L.B.
> oracle_at_russiantreasure.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Apr 29 1999 - 20:17:43 CDT