Re: real time app. on Oracle

Hi, Hongying,

I've read all messages in this thread. I think the only way to achieve your goal exactly is to write your own program that runs periodically, say every 10 seconds. First you define priorities in a table, maybe based on schemaname, or osuser, as in v$session. Your program checks v$sessstat for all sessions for "CPU used by this session" and kills those exceeding the assigned limit so they roll back. This is easy. It's a little harder to achieve your first goal. You keep checking v$lock and v$session_wait. If a higher priority session is waiting for enqueue which is showned by a lower priority session, kill the latter session.

That's a project. Once you're done, you may set up a web site for people to download your code.

Yong Huang

hongying yin <hongying.yin_at_nokia.com> wrote in message news:<3CEBB4FD.BB644E89_at_nokia.com>...
> 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.
Received on Fri May 24 2002 - 09:25:47 CDT