Re: In-memory Database

It's easy. For start, make sure your data buffer is large enough: increase db_block_buffers parameter in your init<sid>.ora file so that db_block_buffers * db_block_size is appr. 100Mb or more. Another thing you can do, is to make sure tables and indices stay cached: alter table (or index) <table or index name> cache;

Alik wrote:

> I'm new to Oracle.
> I have a relatively small database (~100MB) and 1GB
> of memory on the server. What I want to to to speed up
> little bit is to put the database into memory.
> So all reads will be from memory and all writes - to
> the disk with memeory also updated.
> How can I do this? How to place whole database into the
> memory.
>
> Thanks

--
Oleg Pshenitsyn
Database Administrator
VACATION.COM