Re: Memory based tables
- From: Gints Plivna <gints.plivna@xxxxxxxxx>
- To: OFlorian.geo@xxxxxxxxx
- Date: Tue, 19 Jul 2005 11:28:50 +0300
You can check about enhanced commit in 10.2 in first link provided
below. Of course the other question is - to use or not to use the
latest version that is out only for few weeks.
Radoulov, Dimitre <cichomitiko@xxxxxxxxx> to oracle-l
More options Jul 9
Check these articles,
I think the new features are really interesting:
Part 1-SQL and PL/SQL Features
http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part1.html
Part 2-Manageability Features
http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part2.html
Regards
Dimitre
On 7/19/05, Ondrej Florian <OFlorian.geo@xxxxxxxxx> wrote:
> Hello,
> I would like to know if there is such a thing as memory based table
> in Oracle. What I mean be memory based is table which doesn't require
> any disk IO for storing or retrieving data. I am working on a project
> that includes price database which is obviously very IO intensive by
> nature. Since I can afford to loose some data during the server
> crash, I though about putting them all into memory. The reason why I
> cannot use something like MySQL or even some home grown kind of
> solution is that prices are to be combined with our static data and
> it is essential to keep everything in one database. One part of the
> solution is to cache data in the database for read access and this
> works very well. The problem is the write access. Since price updates
> are spread over long time period, it is very hard to do any type of
> mass import. So essentially you end up with a lot of small insert,
> update, delete transactions which means the the the performance
> suffers. Now I tried to do something every stupid. I moved the redo
> logs into a ramdisk. Something that the real DB would never do. Hey,
> I am not a DBA, I am programmer :-). Anyhow I got about 10x faster
> throughput without sweat. Obviously the problem is what happens when
> there is a crash. Loosing the data it self is not big deal. The
> problem is that as I found out Oracle has really hard time dealing
> with deleted redo logs. In the end I had to reinstall the whole
> database. Not really surprising outcome, but it got me thinking. Is
> there a safe way to eliminate disk IO in Oracle ?
>
> I hope my question is understandable enough,
> Thanks for your response,
>
> Ondrej
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
