Re: Oracle AQ Retry with Delay Interval

I actually logged a TAR with Oracle on this and was told that it was expected behavior. Apparently, the background process does index maintainance which causes the logging. My problem with it is that on my totally idle database, I would see 2 gig of redo over a three day period. It seems a bit excessive considering I never had a queue with over 100 messages in it.

"Eric" <eric_at_deptj.demon.co.uk> wrote in message news:70568f73.0112070213.69eaadf3_at_posting.google.com...

> "John Darrah" <jdarrah_at_veripost.net> wrote in message news:<546349ba0394a1ddaae5e905b7ee6c41.36240_at_mygate.mailgate.org>...
> > Have you set the AQ_TM_PROCESSES parameter? It needs to be set to a number > 0
> > for
> > the delay feature to work.
>
> >Beware, turning this parameter on generates a lot
> > of redo
> >
>
> Why?
>
> Thanx,
>
> Eric

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