Re: Oracle in memory

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 5 Dec 2001 23:00:48 +0800
Message-ID: <9uld5b$mq8$1@clematis.singnet.com.sg>

Back in Oracle 7.0 days, I had put the TEMP tablespace (and I knew it was actively used) on a RAM file system but didn't see any noticeable improvement in performance. I was surprised. Never did try it with any other tablespaces.

Hemant K Chitale

"Ryan" <rjmunson_at_ryanmunson.com> wrote in message news:Xns916E1D8AB563rmunsonhostpronet_at_137.201.104.16...
> All,
>
> Has anyone ever tried running an entire database in memory? Make a
> filesystem out of swap space, create the data and index files in that
> filesystem...Maybe for saftey put the system file and archlogs on an
actual
> disk. You could even ensure data integrity by mirroring the memory to an
> actual disk backed filesystem.
>
> I would be curious to see if anyone has played around with the idea.
>
> I beleive it could work, writes to the mirrored structure would be the
same
> as normal. However reads to the filesystem would be smoking!! Most I/O
> controllers will take the data from whoever can deliver it the fastest, in
> this case the "ram disk" would return the blocks in a heartbeat thus
> completing the read. It would be like "caching" the entire database into
> the database buffers.
>
> Let me know your thoughts, and also if someone has tried this before....
>
> Ryan
Received on Wed Dec 05 2001 - 09:00:48 CST