All geek questions in one place

Is there a way to eliminate Oracle change notifications?

I am trying to use oracle change notifications (API from the Dbms_Change_Notification package) to update complex materialized views. I set a change notification for my table with my PL / SQL callback, and I see in the USER_CHANGE_NOTIFICATION_REGS view that my change notification is set correctly. When developing oracle servers with notifications of low load changes, it is called as expected immediately after fixing the observed table. But on real high-load servers, it seems like change notifications are never called.

Is there a way to fix the problem, why notifications of changes do not cause when they will be called, what error occurs when they are called, etc.?

PS I am using oracle Version 10.2.0.3.0

+3
source share
1 answer

On your production system, did you set the initialization parameter JOB_QUEUE_PROCESSES? It must be set to a non-zero value.

Did the user who registered the requests received the rights to the production database (CHANGE OF CHANGES and execution in DBMS_CHANGE_NOTIFICATION)?

0
source

Source: https://habr.com/ru/post/1751028/

More articles:


All Articles