Re: Creating an In-memory Database

St up a KEEP buffer pool of 50 Mb,
and change the storage on the table so
that its buffer pool is the KEEP pool, then define the table as a CACHE table.

This should ensure that the table is loaded into buffer and never flushed.

There is an article on my website under (I think) Features -> 3 buffers

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Kyonghun Jeon wrote in message <37D7173B.20C3C5F9_at_ktnet.co.kr>...
>I have a table with 230K records.
>The size of the table is just 40M bytes.
>Having a Linux machine with 256M memory,
>I hope to configure a In-memory Database.
>How can I make such an in-memory database?
>
>First I increased the db_block_buffers to 51200.
>My Oracle 8.0.5 is configured to use 2 K block buffer.
>When I use full table scan query such as
> select count(*) from items where name like '%TV%';
>It always takes 90 seconds.
>It seems that it doesn't use any large buffer advantage.
>
>Thanks for any assistance.
>
>
>Kyonghun Jeon
>
Received on Thu Sep 09 1999 - 02:14:26 CDT