Re: Oracle recommends rebuilding IOTs in AQ to reduce redo

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 4 Jan 2008 21:17:29 -0500
Message-ID: <9177895d0801041817xc793c97xd6833f96fa524ecb@mail.gmail.com>

This is true, AQ is implemented using simple transactional logic ... just multiple IOTs are inserted and deleted and updated based on subscribets etc.

Raj

On Jan 4, 2008 7:51 PM, <ryan_gaffuri_at_comcast.net> wrote:

> I think an enqueue is basically an insert to an IOT and a dequeue is a
> delete.
>
>

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

Received on Fri Jan 04 2008 - 20:17:29 CST

This message: [ Message body ]
Next message: Sanjay Mishra: "AIX RAC Patches"
Previous message: Jeremiah Wilton: "Oracle jobs in Seattle and DB Replay in 10g"
In reply to: ryan_gaffuri_at_comcast.net: "Oracle recommends rebuilding IOTs in AQ to reduce redo"
Next in thread: Jonathan Lewis: "Re: Oracle recommends rebuilding IOTs in AQ to reduce redo"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message