Oracle performance in high-volume data storage.

Hi there,

We have a data collection running 24h (several processes in different workstations) and we get about 200M of data each day. At the moment we store this into proprietary file for size and performance reasons. Unfortunately, this makes the later analysis of the data a bit difficult with any standard tools.

However, now we would like to make the accessing and analyzing of the data easier. That would mean that we would store the data into Oracle (that's what we use elsewhere). The database would be probably running on Sun or HP-UX.

Our requirements:
- Constant database writing, rate being about 2,5k / second
  this writing must not cause any blocking to the writer processes.
- Reading at the same time in bursts (when someone runs the analyzing tool).

• The data will be stored for about 2 weeks and then the data will be deleted every day. So the database will grow up to 3GB or so.
• The data contains a timestamp and about 20 numeric fields.
• The database is mission-critical and it must be on-line 24h.
• The queries will be made on the timestamp + a numeric field or two.

I have the feeling that Oracle should handle this without any problems.

What is your "gut" feeling about this? Should we look into parallel processing version? Any references to any high-volume storage applications?

• Petri