Re: excessive logging with aq_time manager

If you don't have the init parameter AQ_TM_PROCESSES set to a number > 0, and you aren't using
delay time in your queues, you won't see the logging. I actually logged a TAR with Oracle on this and was told that this is expected behavior due to the background processes doing index maintainance. It seems like there is room for improvement in this particular part of the AQ application.

"Arun J Muthalaly" <arunjacob_at_hotmail.com> wrote in message news:c0da5cec.0110260531.298557c9_at_posting.google.com...

> John,
>
> I am using Advanced queuing on Oracle 8.1.6.3 and 8.1.7.0 . not seen
> massive redo generation before.
>
>
> john.darrah_at_spambadusa.net (John Darrah) wrote in message news:<1003510389.670437_at_proxy.storm.co.za>...
> > Is anyone using the time manager with Advanced Queueing? I turned the
> > time manager process on yesterday and between 6pm and 9am there was nearly
> > a gig of redo generated. There was no other activity on the database so
> > I'm somewhat confused.
> >
> > Posted via www.orafocus.com - Focusing on the World of Oracle

-- 
Posted from d225s240.hotbank.com [63.83.225.240] 
via Mailgate.ORG Server - http://www.Mailgate.ORG