Re: Locking
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 21 Oct 2005 10:44:59 -0700
Message-ID: <1129916697.472011_at_yasure>
>
> waiting
>
>
>
> Do you mind give me more hints? I browsed and search
> lots of websites including Oracle, OTN, google, newsgroup etc
> but have not much related to this.
>
> Thx.
Date: Fri, 21 Oct 2005 10:44:59 -0700
Message-ID: <1129916697.472011_at_yasure>
Pat wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1129829572.483502_at_yasure...
>
>>Pat wrote: >> >>>Hi all, >>> >>>in oracle form when user locks a row. some other process which needs >>>the same row will need to wait until the first user commit/rollback. >>> >>>is it possible to write something to alert the user that someone is
>
> waiting
>
>>>for the resource? >>> >>>thx >> >>Look at Advanced Queuing and timers. >>-- >>Daniel A. Morgan >>http://www.psoug.org >>damorgan_at_x.washington.edu >>(replace x with u to respond)
>
>
> Do you mind give me more hints? I browsed and search
> lots of websites including Oracle, OTN, google, newsgroup etc
> but have not much related to this.
>
> Thx.
You can use Queues to message between sessions, between instances, and from server to application.
You can use timers to execute code that checks, periodically, for messages from queues.
HTH
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Fri Oct 21 2005 - 19:44:59 CEST