8.27 V$AQ_NONDUR_REGISTRATIONS

V$AQ_NONDUR_REGISTRATIONS provides information about non-durable subscriptions.

Column Datatype Description

REG_ID

NUMBER

Registration ID

SUBSCRIPTION

VARCHAR2(128)

Subscription name

LOCATION

VARCHAR2(256)

Location name

USER#

NUMBER

User ID

USER_CONTEXT

RAW(32)

Context the user provided

CONTEXT_SIZE

NUMBER

Size of the context

NAMESPACE

NUMBER

Subscription namespace

VERSION

NUMBER

Database version number

STATE

NUMBER

State of the registration:

  • ENABLED: The registration is enabled for notification

  • STOPPING: The registration is in a transient state before it becomes DISABLED

  • DISABLED: The registration is disabled for notification

  • DEAD: The registration does not exist any more, and it is marked for deferred cleanup.

QOS

NUMBER

Quality of service

REG_TIME

TIMESTAMP(3) WITH TIME ZONE

Time of registration

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also:

Oracle Database Advanced Queuing User's Guide for more information about Oracle Database Advanced Queueing