Re: In-memory Database

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

Cranking up db_block_buffers to more than 100M will simulate to some degree what you are after.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse