Re: Oracle in memory

Hi,

yes, we did this in a major R/3 benchmark. We placed a lot of read-only tables in a single tablespace which resided on a hybird memory/physical mirror disk (so all reads were satisfied from the memory disk). But, we measured no improvement of performance of any significance.

My believing here is: give the memory to oracle directly by increasing the buffer cache and maybe pinning tables into the cache.

Regards
Stephan

"Ryan" <rjmunson_at_ryanmunson.com> schrieb im Newsbeitrag 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 Thu Dec 06 2001 - 02:11:27 CST