Re: Oracle Question

Bhushan wrote:

> I wanted to run a program, program running
> continuously to receive a record when sent, then load this record to
> Oracle real time. They would have to be received from a real time
> process,that reads a port and if it sees a message loads to Oracle.

Oracle is not a real-time database as far as real-time systems go. For starters, you will need to look at real-time operating systems first.

Likely this is not what you mean - many refer to "real-time systems" when in fact they mean semi or pseudo real-time. Refer to Wikipedia/Google for details on what constitues a real-time computer system.

An Oracle instance can handle millions of transactions per second. A single Oracle process can insert 1000's of rows into Oracle per second. Nothing unusual about it - as long as Oracle fundementals are adhered to ito scalability and performance. Here is my brief list of these fundementals:

#1 - use bind variables (eliminate hard parsing and shared

     pool fragmentation)

#2 - re-use statement handles in the client (eliminate soft

     parsing)

#3 - be aware of what overheads are caused on an insert

     ito indexes, triggers, constraints and so on

FWIW, we capture "real-time" network traffic from routers (big routers). A single capture process is able to insert over 1500 rows/second on average into Oracle. Nothing special about the hardware - simply the above 3 steps are very strictly adhered to.

--
Billy