Xref: alice comp.databases.oracle.server:65085
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!colt.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Creating an In-memory Database
Date: Thu, 9 Sep 1999 08:14:26 +0100
Message-ID: <936862801.21872.0.nnrp-02.9e984b29@news.demon.co.uk>
References: <37D7173B.20C3C5F9@ktnet.co.kr>
X-Trace: news.demon.co.uk 936862801 nnrp-02:21872 NO-IDENT jlcomp.demon.co.uk:158.152.75.41
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 38


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@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
>