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