Re: Maintaining Advanced Queue IOT/Index Objects: _aq_tm_scanlimit

Version is pretty important for AQ, recent versions probably don't require coalesce much.

On 1 Sep 2016 18:40, <fmhabash_at_gmail.com> wrote:

> Our application relies heavily on use of Oracle AQ feature. Any attempt to
> coalesce, rebuild, or shrink these queue objects is faced with ORA-00054:
> resource busy. Stopping the queues is not an option.
>
>
>
> We are considering having the QMON process take charge of this garbage
> collection automatically by setting ‘_aq_tm_scanlimit’ to non-zero value.
>
>
>
> I have seen no authoritative description notes for this parameter on MOS,
> Google, or anywhere. The single note I found indicated this parameter
> accepts a number to set scanlimit on time managers. Not sure though, is
> this a counter or time limit and how to verify the effect of altering it
> e.g. view, process limit,etc.
>
>
>
> Appreciated.
>
>
>
>
> ----------------------------------------
> Thank you
>
>
>

--
http://www.freelists.org/webpage/oracle-l