Re: dbms_alert

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 11 Jul 2003 15:04:57 -0700
Message-ID: <336da121.0307111404.1bfbf331@posting.google.com>

s.rosa_at_printcom.deutschepost.de (stan) wrote in message news:<3f0ea148.17412197_at_news.deutschepost.de>...
> Hallo *,
>
> we got a problem under oracle 7.3.4.4.0. The following problem we
> have:
>
> We have two db-scheme (scheme1, scheme2). In scheme1 we use the
> dbms_alert.signal(contex1....) to send a signal concerning to a
> special context (context1).
> In scheme2 we use the dbms_alert.waitone(context1) to fetch signals in
> the context1.
>
> Sometimes we have the problem, that some signals will disappear. I
> think it's a problem with the buffer for signal. Do I have the chance
> to manipulate this buffersize?
>

dbms_alert sends message on commit only. Are you sure signals you lose are from sessions where commit did happen?
Buffersize shouldn't be a problem. dbms_alert uses dbms_pipe to send messages. If buffer is overflown, your sending session would wait until bufferspace is available.

> Thanks
> Christoph
Received on Fri Jul 11 2003 - 17:04:57 CDT