Oracle in memory 
Author Message
 Oracle in memory

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



Sun, 23 May 2004 15:10:53 GMT
 Oracle in memory

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


Quote:
> 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



Sun, 23 May 2004 23:00:48 GMT
 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



Quote:
> 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



Mon, 24 May 2004 16:11:27 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. VC - Oracle odbc memory leak

2. Oracle/RDO Memory Leak?

3. Solaris/Intel Oracle 8i Memory

4. Oracle leaks memory under Solaris X86 ?

5. Personal Oracle 8i Memory requirements

6. Q: Alpha / NT / Oracle Server - Memory Leaks?

7. Oracle Client memory leakage

8. Oracle 8i memory on AIX?

9. oracle 7.3 memory leak in solaris 2.6

10. Oracle Shared Memory Problem (DEC UNIX 4.0)


 
Powered by phpBB® Forum Software