Re: Oracle recommends rebuilding IOTs in AQ to reduce redo

FIFO
10.2.0.1
single row queue

• Original message ---------------------- From: "Greg Rahn" <greg_at_structureddata.org>
  > The coalesce would be a better option IMO (I've personally used this
  > as a recommendation from the AQ dev team) and it can be done while the
  > workload is in progress, while a rebuild requires the queues to be
  > stopped.
  >
  > Another recommendation I received is *not* to use ASSM tablespaces for
  > the queues.
  >
  > What db version is this?
  > What is the queue navigation type (first or next message)?
  > Are you doing single row or array enqueues/dequeues?
  >
  >
  > On 1/6/08, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
  > > In simple indexes, the optimum solution to this type of problem
  > > is usually a coalesce, rather than a rebuild. Given that Queues
  > > are IOTs that you're not really supposed to know about, it's
  > > not too surprising that Oracle has suggested a rebuild instead.
  >
  > --
  > Regards,
  >
  > Greg Rahn
  > http://structureddata.org
  

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