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

本站中文解释

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

See Also:

“USER_SUBSCR_REGISTRATIONS”


数据运维技术 » Oracle 视图 DBA_SUBSCR_REGISTRATIONS 官方解释,作用,如何使用详细说明