Hi,
I am on Oracle 11.2.0.4 and developing an application using CQN (Continuous Query Notification).
It all works fine. When a certain table is changed, I am notified with the changes (and if requested, the ROWIDs of each row changed).
What I am not sure is, what is the technology being used under the hood ? Is Oracle looking into the redo / undo information ? or it creates a bunch of triggers in there ? or what else ?
I would like to understand this, before using CQN on large scale. I would feel slightly more confident about the whole things and can probably help me in configuring vital parameters of the database.
Thanks in advance.