Re: real time app. on Oracle

Hey, this is what TPM's are for, like BEA's Tuxedo. Transaction (or Teleprocessing) Processing Monitors, all the way back to IBM CICS.

Do not ever count on process priority for this mechanism, and do not use UNIX process scheduling / job priority in an attempt to do this with the Oracle core.

Oracle's AQM is helpful if you wish to go that route; also both BEA and NCR have TPMs that can coordinate transactions.

It's a lot of work, but if it is critical that first come, first served be part of your paradigm, a TPM would be part of the answer. As well as raw i/o, where DB writes are guaranteed and not queued through the UNIX file management systems.

RSH.
"hongying yin" <hongying.yin_at_nokia.com> wrote in message news:3CEBB4FD.BB644E89_at_nokia.com...
> Hi,
>
> I'd like to know how the Oracle can support the real-time application.
> E.g, can Oracle set up the priorities for the processes, so that when
> the higher-priority process came to (modify the same record), the Oracle
> can roll-back the low-priority process and let the high priority process
> to operate first.
>
> Another issue is if it's possible that we can set the time-out in DB so
> that if the process takes too long time, Oracle can roll it back.
>
> Thnaks a lot in advance.
>
>
> Best Regards,
>
> Hongying Yin
>
>
Received on Wed May 22 2002 - 13:52:51 CDT