Re: real time app. on Oracle

Hi

I'm not entirely sure how/why you would apply suggest a definition of a real-time application.

However you might want to explore the features available with the Database Resource Manager. It provides the ability to group users into different categories and define different levels of priority to each group. You can also ensure that if a particular user were to use up too much resources, it can stop that unit of work from executing in the first place.

It might be what you're looking for.

Regards

Richard

"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 - 23:36:58 CDT