Oracle 视图 DBA_SUBSCR_REGISTRATIONS 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 DBA_SUBSCR_REGISTRATIONS 官方解释，作用，如何使用详细说明 10-15

本站中文解释

Oracle 视图 DBA_SUBSCR_REGISTRATIONS 主要用于查询数据库订阅注册信息，显示注册在每个数据库上的订阅。

该视图列出了用于在数据库中注册某个订阅的各个属性，其中包含了订阅的目标源和执行位置。

使用该视图，可以获取某个数据库上的所有订阅注册信息，以及每个订阅注册信息中指定的执行位置。

该视图可以使用以下命令访问：

SELECT * FROM DBA_SUBSCR_REGISTRATIONS;

官方英文解释

DBA_SUBSCR_REGISTRATIONS displays information about all subscription registrations in the database.

Related View

USER_SUBSCR_REGISTRATIONS displays information about the subscription registrations owned by the current user.

Column	Datatype	NULL	Description
`REG_ID`	`NUMBER`		Registration ID
`SUBSCRIPTION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the subscription registration. The subscription name is of the form `schema.queue` if the registration is for a single consumer queue or `schema.queue:consumer_name` if the registration is for a multiconsumer queue.
`LOCATION_NAME`	`VARCHAR2(256)`	`NOT NULL`	Location endpoint of the registration
`USER#`	`NUMBER`	`NOT NULL`	Internally generated user ID
`USER_CONTEXT`	`RAW(128)`		Context the user provided during registration of PL/SQL registrations or an internally generated context for OCI registrations
`CONTEXT_SIZE`	`NUMBER`		Size of the context
`NAMESPACE`	`VARCHAR2(9)`		Namespace of the subscription registration: `ANONYMOUS` `AQ` `DBCHANGE`
`PRESENTATION`	`VARCHAR2(7)`		Presentation format of notifications: `DEFAULT - Binary` `XML`
`VERSION`	`VARCHAR2(8)`		Database version: `8.1.6` `10.2` `11.1`
`STATUS`	`VARCHAR2(8)`		Status of the registration: `DB REG` – Database registration `LDAP REG` – LDAP registration
`ANY_CONTEXT`	`ANYDATA`		AnyData user context
`CONTEXT_TYPE`	`NUMBER`		Type of the user context
`QOSFLAGS`	`VARCHAR2(64)`		Quality of service of the registration: `RELIABLE` – Reliable notifications persist across instance and database restarts `PAYLOAD` – Payload delivery is required. It is only supported for client notification and only for RAW queues. `PURGE_ON_NTFN` – Registration is to be purged automatically when the first notification is delivered to this registration location
`PAYLOAD_CALLBACK`	`VARCHAR2(4000)`		Any callback registered to serialize the notification payload
`TIMEOUT`	`TIMESTAMP(6)`		Registration timeout
`REG_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		Time of the registration
`NTFN_GROUPING_CLASS`	`VARCHAR2(4)`		Notification grouping class
`NTFN_GROUPING_VALUE`	`NUMBER`		Notification grouping value
`NTFN_GROUPING_TYPE`	`VARCHAR2(7)`		Notification grouping type: `SUMMARY` `LAST`
`NTFN_GROUPING_START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		Notification grouping start time
`NTFN_GROUPING_REPEAT_COUNT`	`VARCHAR2(40)`		Notification grouping repeat count, or `FOREVER`

广州葆元健康生物科技有限公司

Oracle 视图 DBA_SUBSCR_REGISTRATIONS 官方解释，作用，如何使用详细说明

本站中文解释

官方英文解释