Re: Queue tables and buffer busy waits

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 17 Oct 2010 19:47:28 +0000 (UTC)
Message-ID: <i9fjsg$hai$19_at_solani.org>

On Fri, 15 Oct 2010 09:08:46 -0700, joel garry wrote:

> $ oerr ora 10854
> 10854, 00000, "Sets poll count used for AQ listen code under RAC" //
> *Cause: NA
> // *Action: THIS IS NOT A USER ERROR NUMBER/MESSAGE. THIS DOES NOT NEED
> TO BE
> // TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL
> TESTING.
>
> (Speculation: Fix for Bug 3830972 doesn't perform well across nodes,
> but better than a fail. See dbms_aq.listen Works Inconsistently in a
> RAC Environment [ID 762715.1])

Thanks Joel. This confirms what I already knew. DBMS_AQ doesn't perform well across RAC.

-- 
http://mgogala.byethost5.com

Received on Sun Oct 17 2010 - 14:47:28 CDT