Version is pretty important for AQ, recent versions probably don't require
coalesce much.
On 1 Sep 2016 18:40, <fmhabash@xxxxxxxxx> 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