oracleaq_at_gmail.com wrote:
> I'm using Oracle 9i 9.2.0.5 with Advance Queue option. Sometimes Oracle
> can't propagate messages to the remote DB. Observing v$lock i see TM
> mode 3 lock on _i and _h table ( _i and _h are IOT table created at
> the same time as the out queue).
>
> The only solution so far is decrease the number of messages stored in
> the out queue.
>
> Is there other solution ?
> Thanks.
What is the number of messages?
How is the queue configured?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Dec 06 2006 - 10:59:11 CST
