Oracle 视图 DBA_CHANGE_NOTIFICATION_REGS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_CHANGE_NOTIFICATION_REGS显示当前使用数据库Change Notification注册表，包括用户名、表名等信息。
DBA_CHANGE_NOTIFICATION_REGS视图允许查询注册表下的所有Change Notification注册信息，以响应表的变化，实现复杂的功能。但由于这个视图的查询速度较慢，一般不会在实际中使用，尤其是当数据库内注册表非常大时更是如此；因此，一般情况下，DBA_CHANGE_NOTIFICATION_REGS视图的用途仅限于调试和开发这两种场景。
官方英文解释
DBA_CHANGE_NOTIFICATION_REGS describes all change notification registrations in the database.
Related View
USER_CHANGE_NOTIFICATION_REGS describes the change notification registrations owned by the current user. This view does not display the USERNAME column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
For invoker’s rights units, the user creating the registration For definer’s rights units, the owner of the registration |
|
|
|
|
Internal registration ID |
|
|
|
|
Registration flags |
|
|
|
|
Notification callback |
|
|
|
|
Operations filter (if specified) |
|
|
|
|
Transaction lag between notifications (if specified) |
|
|
|
|
Registration timeout (if specified) |
|
|
|
|
Name of the registered table |
See Also:
“USER_CHANGE_NOTIFICATION_REGS”
