Is there a way to troubleshoot change notifications in Oracle?_问答_开发者

Is there a way to troubleshoot change notifications in Oracle?

开发者 https://www.devze.com 2023-01-04 09:19 出处：网络

I\'m trying to use oracle change notifications (API from Dbms_Change_Notification package) to update complex materialized views. I install change notification for my table with my PL/SQL callback and

相关专题：oracle plsql

I'm trying to use oracle change notifications (API from Dbms_Change_Notification package) to update complex materialized views. I install change notification for my table with my PL/SQL callback and I can see in USER_CHANGE_NOTIFICATIO开发者_JS百科N_REGS view that my change notification is installed properly. On development oracle servers with low load change notifications are called as expected just after commit to observed table. But on real servers with high load it looks like change notifications are never called.

Is there any way to troubleshoot why change notifications are not called, when they are going to be called, what kind of error happens when they are called and so on?

P.S. I am using oracle Version 10.2.0.3.0

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

Has the user registering the queries been granted the right privileges on the production database (CHANGE NOTIFICATION and execute on DBMS_CHANGE_NOTIFICATION)?