Re: Oracle Question
- From: "Billy" <vslabs@xxxxxxxxxx>
- Date: 29 Sep 2005 03:51:16 -0700
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
.
- Follow-Ups:
- Re: Oracle Question
- From: Frank van Bortel
- Re: Oracle Question
- References:
- Oracle Question
- From: Bhushan
- Oracle Question
- Prev by Date: Re: How to check if installation is successfull
- Next by Date: Ideal configuration on 3 disks
- Previous by thread: Oracle Question
- Next by thread: Re: Oracle Question
- Index(es):
Relevant Pages
|
|
